Hey! Every time that a company have a new business with a client, it generates a new record on the table "Businesses". My idea is to show all the clients that a company made business before, but I don´t want duplicates on that list. So, how do I only show distinct values?
The relational model you describe seems to be a common N:N relationship between 3 tables.
You should base the Table list on Client. But because its not directly related to Business you will need to change the type of list to 'Unfiltered list'. The unfiltered may lead to misinterpretation but it is meant to say the relation to the base area of the form is not mandatory.
Then you add you N:N filter to the list:
In the menu systems its easier to do because there is a 'N:N list' continuation that has this kind of filter built into it.
About This Community
|Asked: 11/25/19, 1:18 PM|
|Seen: 400 times|
|Last updated: 11/26/19, 10:08 AM|