Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rental database- need code for a search

Status
Not open for further replies.

Ashlious

Vendor
Mar 9, 2004
1
GB
im designing a database for renting vehicles. I am producing a module that finds a vehicle using a registration number and on a specific date. what is the code i need for this to happen. I have a reservations table where the dates and registrations of vehicles are kept but the output of the seaarch i want the customers details this is linked into the reservations table using customer ID. Customers also have their own table with their details which links to reservations table using customer id.

Sorry but i am a total newbie at all this. I dont understand exactly what goes on but i really need your help! i will be very grateful.
Thnkyou
 
Hello Ashlious,

I would build a query and set this in a Form. Set a text field where you enter the reg ID and then after klicking enter information will be shown in a under Form. This is one of the easiest ways to get the information you want.

regards
Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top