Newbies GSbullroc Posted July 23, 2000 Newbies Share Posted July 23, 2000 I am working on a database for a bus charter company, I have a value list of drivers and one for buses as these two items are sledcted and placed into service I need to show them in use, for a date and time and then release them when this time has pasted . Any ideas? ------------------ Link to comment Share on other sites More sharing options...
LiveOak Posted July 24, 2000 Share Posted July 24, 2000 Create a transaction file where a record is a bus/driver. If you also have a file for buses and a file for drivers, you can use information from the transaction file to "mark" buses and drivers as "in use" and even control the display of bus numbers and driver names on your selection lists (don't display those that are in use). A startup script can check the date and delete records from the transaction file to release buses and drivers for asssignment.-bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8683 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now