AnsweredAssumed Answered

Search with relationship and linked value

Question asked by f.i.sciences on Sep 29, 2018
Latest reply on Oct 1, 2018 by f.i.sciences

Hello,

 

I have a table Clients with relationship of table Addresses (ID and parent_ID). When I do a search base on the LastName and City field in the Addresses table, how can I tell which Address meat the search criteria?

 

Because it will display the Clients that meet the criteria, but all addresses of the client will be displayed.

 

Is there an easy FMP way?

 

Thank you.

Outcomes