I have in my database a car table, linked to this by ID is an accident table and a defect Table.
I have made another table in which I place records for vehicles not current by an append query, i,e, car table history.
If I make history tables for the Defects and Accidents can I make the one query to move all this information at once as it is connected . If so, How?
Thanks for any help
I have made another table in which I place records for vehicles not current by an append query, i,e, car table history.
If I make history tables for the Defects and Accidents can I make the one query to move all this information at once as it is connected . If so, How?
Thanks for any help