How to add a new Location, an Appraisal and Insurance Information.
I would like to add a new location for a car someone bought. I already have an Invoice with a Client, Address, Car, but the Client moved so the car is stored at a new location? I do not want to change the original invoice. How would add a new address/ location for one or more Cars? Furthermore, some cars that he has are at a third different address? Then I would like to enter an appraisal for that specific car. I would also like to be able to enter his Insurance information to make it more seamless for the Client
I have a Client Table, Invoice Table, LineItems Table, Address Table, Car Table. Do I need a separate Insurance and Appraisal table - an appraisal could be updated every year as could the Insurance policy or policy number.
I would like to be able to run a report showing the client his car, where it is located, an appraisal and insurance information. What is the best method?