2 Replies Latest reply on May 23, 2014 11:59 AM by mattxkim

    Filtering through layers of relationships


      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?


      Thank you.