|
| |
|
|
polyclay
Posts: 30
Joined: 10/3/2003
Status: offline
 |
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?
< Message edited by polyclay -- 1/23/2005 11:05:49 >
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
