I'm currently having problems with my relationship database.
Currently, When i search for the tour ID, details of customers going for that tour will appear.
However, currently when i search for tour ID, Filemaker will show up the past tour ID based according to what they have went previously, instead of the tour ID that i am searching.
Is there anyway to solve this problem?
Attached below is the image of my database relationshop chart.