Hello
dataset looks like this:
AppName User
AAA john
BBB john
AAA elvis
BBB elvis
CCC elvis
In one view I want to see distinct rows to choose from:
john
elvis
when click on elvis, i want to see his app list in another view
AAA
BBB
CCC
Solved! Go to Solution.
Create Table
Users:
User_ID | User |
and create another table:
Applications:
Application_ID | User_ID (Ref) | Application Name |
Do the relation between the tables using column Type REF and selecting the source table:
In this way when you click the user you can see the related applications.
See below
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |