Showing many to many?

[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.

 

[Calvin Luttrell]

Ben,

You can bind your controls to dataviews and then apply filters to the views
on the click even in the datagrid. You need to look at some datagrid
examples.



Calvin Luttrell

How e-commerce is done.

http://blog.projectthunder.com
http://www.projectthunder.com

 

[ben]

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.