I created an inspection app for our collision center, and I am wwondering how can I reference 3 tables.
Here are my tables :
Client - which stores customer data
Vehicle - which stores vehicle information
Inspection - which stores vehicle inspection
- Vehicle is reference to the customer
-Inspection is reference to the vehicle
I created a inspection view for done and not done inspections, and I want to be able to see the customers info withing the Inspection detail view.
I referenced the client table in my inspection table but it doesn’t work, guessing because it doesn’t make any relations to the client table, So I guess I will need to pick this information from the vehicle table that is already referenced to the customer.
Is there an easier way to do this ?