I have an application that I created about a year ago that is working reasonably well, but I am thinking of a redesign for efficency sake, but I cannot think of an easy way to do what I need.
What I would like to have is a table that has many services listed for an aircraft. Each of these services has a status associated with it, some can have 4 status possibilities. There are about 15 different possible services.
I have done this presently with all the possible services in one entry which is grossly inefficient with the file size. I want to list the services individually. The heart of my system now is a browse showing colors for all of the status of each service. This is easy to do with a flat file system when all the services are in one record. I would like to do this with having one to many links to the services and somehow show the status.
I know I could do it with a calc field that looks up the status for each possible item then deal with it that way. I think speed may kill this. There are perhaps 30 flights a day listed on the board with 15 different services for each. This board needs to be refreshed every 30 seconds in several locations. I am trying to figure the fastest way possible to summarize the child data and how to structure it accordingly.
I have several ideas but with my limited knowelege, perhaps there is a very easy way to do this. I figure if they are linked already in a set, perhaps there is a fast way to look up in the children or something like that. Anyway, any thoughts would be appreciated.
What I would like to have is a table that has many services listed for an aircraft. Each of these services has a status associated with it, some can have 4 status possibilities. There are about 15 different possible services.
I have done this presently with all the possible services in one entry which is grossly inefficient with the file size. I want to list the services individually. The heart of my system now is a browse showing colors for all of the status of each service. This is easy to do with a flat file system when all the services are in one record. I would like to do this with having one to many links to the services and somehow show the status.
I know I could do it with a calc field that looks up the status for each possible item then deal with it that way. I think speed may kill this. There are perhaps 30 flights a day listed on the board with 15 different services for each. This board needs to be refreshed every 30 seconds in several locations. I am trying to figure the fastest way possible to summarize the child data and how to structure it accordingly.
I have several ideas but with my limited knowelege, perhaps there is a very easy way to do this. I figure if they are linked already in a set, perhaps there is a fast way to look up in the children or something like that. Anyway, any thoughts would be appreciated.