|
polyclay -> JOIN One Record to Multiple Records--with One Result! (1/22/2005 18:02:42)
|
I want to generate name tags from two tables. It would include one record from the first table and multiple records from the second table.
Each Team has a record in MyGroup. Each Participant has a record in Person, with a many-to-one relationship to MyGroup.GroupID. When Teams sign up for divisions (up to 3), it creates up to 3 records in SelectDiv, which has a many-to-one relationship to MyGroup.GroupID.
I want to generate names tags that include the Person info, and all of the activities recorded for that Person's Team in SelectDiv, on a single name tag.
A usual JOIN creates 3 name tags, one for each activity recorded for the Team in SelectDiv.
I could use 2 separate DRW's and create one name tag per page, but I want several name tags per page for printing.
How can I get all three activities on the same name tag, using one DRW?
|
|
|
|
