value list

[GSbullroc]

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?

------------------

[LiveOak]

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