Showing many to many?

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

I have a dataset with three datatables
Table1 - Groups
---------
GroupID
GroupName

Table2 - UserGroups
----------
GroupID
UserID

Table3 - Users
----------
UserID
UserName

On my form I have three tabs, each tab shows a grid.
Grid 1, on Tab 1, shows all of the group data. You can select a group
here.
Grid 2, on Tab 2, should show only have the Users which are in the
group you selected in Grid1.
Grid 3, on Tab 3, should show all users.

Any idea how to do this? I've been wrestling with this for quite some
time.
 
So I have to do it via code? I thought that there might be some way to
set up the relationship in the dataset and have the grid take care of
everything. I've implemented the functionality using filters, but it
seemed a bit overkill.
 
Back
Top