Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
DISTINCT VALUES
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.
Keep Informed
About the Community
Question tools
Stats
Asked: 25/11/2019 13:18 |
Seen: 1694 times |
Last updated: 26/11/2019 10:08 |