Hi, I'm new to Filemaker (and developing in general) and I have a question about filtering through layers of relationships.
Lets say I have table 1 with: Property Name, Address, Phone number.
Table 2 has: Property Name, AC Unit Serial
Table 3 wil store: Property Name, AC Unit Serial, and Questions 1, Question 2, Question 3....
Table 2 will be related to table 1 and will have a dropdown Property Name list from table 1.
I want table 3 to have a dropdown list of Property Name list (based on table 1) and have a dropdown list of AC Unit serial from table 2, that only matches the Property Name.
Can anyone please provide me with some tips?