We are creating a vehicle inspection app. There is a table of vehicles, which are referenced by a table of inspections.
Our users perform these inspections daily. If there is pre-existing damage on a vehicle, our users have to record the same damage every day to fill their forms out properly. This is tedious.
I was hoping to have a third table, inspection_damage, as an ‘is part of’ table that would contain all the past recorded damage records from all other users. Then, when performing new inspections, the techs could add to the list if new damage exists.
This table would have to reference the ‘inspections’ table, and therefor would be tied to that particular walkaround instance. So every new inspection will begin blank.
Is there a way to make this work so that upon creating a new record in a table called ‘inspection’, referenced to a specified vehicle, it will display a REF for that vehicle and a third table of outstanding damages?