AnsweredAssumed Answered

Filtering through layers of relationships

Question asked by mattxkim on May 23, 2014
Latest reply on May 23, 2014 by 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.

Outcomes