Table structure - transfering information

icemac

Registered User.
Local time
Today, 13:33
Joined
Jul 17, 2006
Messages
31
I am creating a database for a hyperthetical car hire company. I have a table for the customer details, a table for car details, a mid table with current car hire information. I want to create a table for previous car hire information. Is there a way that i can transfer the details from the current car hire table to the previous car hire table without copying and pasting? (when the customer returns their car)
 

Attachments

Unless I misunderstand you, this structure doesn't make a huge amount of sense to me.

Why not create a single car hire info table that has two date fields for each rental transaction (start date and returned date). Cars currently out on hire will have a start date but not a returned date. Cars that have previously been hired will have a returned date in the field. You can query your table using that information as criteria to limit your query to the group you are interested in.

When the customer returns the car, just enter the date into that field.

If ever your table gets too large, just archive the records for previously hired cars that are more than x years old.
 

Users who are viewing this thread

Back
Top Bottom