I've been doing a significant amount of development with ASP and Dreamweaver, but I've run into one problem I just can't seem to solve.
I have a simple set of master > Detail page sets, where a URL passes a variable from a selection page to a details set. Not too horribly tough, right? Well, I want the details page to show some more information about this table and its relationships to others. (see attached file for visual)
I have a table named memebers with these fields:
(...and several other fields not really relevant to post)
Another table, named groups with these fields
And a third table MembersInGroups
containing each relationship of a group to members
GroupName (foreign Key to groupID
MemberName (foreign Key to memberID
SO, here's what I have to do:
I need to show what members are in a group in a group detail page, and I also have to show what groups a member is in. How would I do that using the unique variable passed from the master to the detail page for groups and members?
And if you're REALLY good......
...How would I construct a page to delete these relationships?