I am new to file maker and have come accross an issue that I can not resolve.
I have a main contact and booking table with a PK of Booking ID
I want to create a values list for cruise companies & the cruise companies ships.
The idea is that if I choose the P&O as the cruise company I will only see P&O's ships.
Here is the relationship that I have made between the tables. Is this the correct to make the above happen.
Can anybody help me please