Hello!

I have two tables related to each other in a n:m relation. To implement this relation I use a third connecting table. Let's say they have to following structure:

Table "User": ID, Username
Table "User-Groups": User_ID, Group_ID
Table "Group": ID, Groupname

A User can be in 0 or more groups and a group can have 0 or more users.

Now I need to display all users of a group in a datagridview.
Or all groups that a user belongs to.

I just have one datagridview - no master-child relation in any way on the same form. I want to filter the datagridview in the way I described.

How is the easiest way to perform this?

Thanks a lot!

You can use 2 usercontrols to store different DataGridView and according to your filter, show or hide the goog usercontrol.