Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 18, 2024 09:05 AM
I am developing software for car appraisers and have structured my database with five tables:
Is this structure appropriate? One potential drawback is that when importing data into related tables, I can only link one table at a time. Ideally, when I add an appraisal along with the vehicle's registration number, the system should automatically identify the associated client (based on the vehicle registration number) and the corresponding enduser (since the client is linked to the enduser).
Sep 18, 2024 10:29 AM
Hello,
Your structure looks fine to me and it should react as expected when adding an appraisal as long as the registration number allready exists in the "vehicle" table.
You may want to add some lookup fields in your table to bring down the information client and enduser. To do that, you need first to add 2 lookup fields in table vehicle to bring down cleint_id and enduser_id from table client and then repeat the operation in table appraisal.
If you add a record in table Appraisal for a registration number that does not exist in table Vehicle, it will create the record in table vehicle with the appropriate primary key, but link with table client will not be done.
Regards,
Pascal
Sep 19, 2024 06:08 AM
Hi Pascal, is there any way I can help me with this? I am willing to a fee.