pimech

Filtering records in a layout through a relationship

Discussion created by pimech on Sep 2, 2016
Latest reply on Sep 14, 2016 by BruceRobertson

Hi,

I have two tables A (1 field, Name) e B (1 field, phone number).

 

A e B are joined with a one-to-many relationship.

 

I created a layout to show A records.

I want to show only A records where exist a relation in B.

For example I have 1000 name records in A and some phone number records in B.

 

In the layout I want to show only names with a phone number.

 

How can I do?

Thanks

Outcomes