Unique Listing

[joeserrone]

Hello Everyone,
I currently have a table that contains Groups. For Example I have Group A, which contains Menu - File - Exit
Group B, which Contains Menu - File - Next - Exit

Multiple People can have access to multiple Groups. So for example User 1 can b part of Group A & Group B

How Do I get a query to display the unique matrix of a User. So for Example User 1 would have his access listed as:
Menu
File
Next
Exit

Since Menu - File & Exit are both common to Group A & Group B

 

[gemma-the-husky]

not sure abuot the next or exit?

but do a query which finds all the menu options in the groups in which you are interested. (without including the group itself)

now this will include duplicate rows - but you can select from the query properties "unique values", which will remove the duplicates (in SQL i think this is the keyword DISTINCT)

slight issue in that the query will be non-updateable.

 

[joeserrone]

Thanks that's exactly what I needed