Referencing 3 tables

[Jimmy_Ruptash1]

Hey guys,

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 ?