I am creating an inspection app for our collision center so that the appraiser can go out, take pictures, and then it will be automatically sent to the estimator.
I have three tables :
There’s one client, but can have multiple vehicles and inspections.
My vehicle table has a client reference, and my inspection table has a vehicle reference. However, when the inspection is created, is shows the customers unique ID, I would like however, to link the inspections to the vehicle itself, so it makes it easier.
Also, there will be multiple images added to the inspection. Should I do a Picture 1 picture 2 picture 3, or should I create another data table ‘‘damages’’, so I can set the number of pictures I want ?
How can I accomplish this task?
Thanks a lot guys.