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

    Filtering through layers of relationships

    mattxkim

      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.