Navigate to View based on Selection

[ArturasF]

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

[Hussein_Osseily]

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.

[Hussein_Osseily · Accepted solution]

See below