Relationships with bridge tables

Hi v-danhe-msft

As I said before, this is not a real possibility. In the real case, we have hundreds of clients and thousands of groups so when I filter a client I also need to see ONLY their groups. In your proposal when filtering by Client_2 all the groups appear but Group_1 belongs to Client_1 so it should not be displayed.

In addition, the relationship between User and BridgeUserTable should be in the opposite direction since a user could belong to several groups, that is:

In summary, I need that when filtering a client:

• Your users are filtered.
• Your groups are filtered and, therefore, you can then filter the users of these client by one of their groups.

Regards,

Daniel