Hi
I posted this as a follow up to another answered question so apologies. Hope someone can help
My database is vehicle management for a mechanic who wants to be able to store all his vehicle data, customer records and raise invoices and keep that invoice data for future reference
I have 3 main tables. Customers, Vehicles and Invoicing.
My relationships are Customers to vehicles one to many and Customers to Invoicing one to many both linked via Customer ID. I then have a one to many relationship between vehicles and invoicing linked via vehicle reg
In a scenario where a customer changes their vehicle, I have a field in the vehicles table called "inactive" and I will tick the box to say yes that is a previous vehicle. I then enter a new vehicle for that customer. If I then raise an invoice (through a form) for the "new" vehicle, and go back into the invoicing table, the invoice for the "inactive" vehicle is showing with the new vehicle details ie Car registration plate when it should be against the "inactive" vehicle. Sorry if that sounds complicated but not at all sure what I have done wrong