|
Your continued generosity and support of FMForums is greatly appreciated. |
Valdrin
enthusiast
Posts: 27
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Intermediate
 Tweet This Post!
|
Hi all,
I have a slight problem. I need to make labels for the back of peoples badges that will have their conference schedule printed on them.
I have two related tables:
Organizers (with a record for each person running one or more events).
Events (a record for each event durning the conference).
I want print a label for each person that will have their name and schedule of events on it, like this:
John Doe
Event A, 2:00PM, Room 4
Event B, 2:00PM, Room 4
Event C, 4:00PM, Room 6
There has to be an elegant way to do this, but I cannot seem to figure it out.
I thank you all in advance for any and all help with this matter.
Val
|
|
|
comment
consultant
Posts: 15781
Post Rank (AVG):
FMP: 7 Advanced
OS: Mac OS X Panther
Tweet This Post!
|
In response to Valdrin
How are the two tables related?
Edited by comment on 03-10-10 11:28 PM. Reason for edit: No reason given.
|
Valdrin
enthusiast
Posts: 27
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Intermediate
Tweet This Post!
|
In response to comment
How are the two tables related?
They are in a one to many relationship.
Each Organizer can run more than one event.
Each Event has only one Organizer.
|
comment
consultant
Posts: 15781
Post Rank (AVG):
FMP: 7 Advanced
OS: Mac OS X Panther
Tweet This Post!
|
In response to Valdrin
I don't think that you have too many choices here: you must print from the Organizers table, with a portal to Events. Otherwise each group will have a different height.
|
Valdrin
enthusiast
Posts: 27
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Intermediate
Tweet This Post!
|
In response to comment
I was really having trouble getting a portal to work with a label layout, but I think I have it fixed out now. I just had to leave the label blank, then add the portal and other fields afterwords.
|
|
Your continued generosity and support of FMForums is greatly appreciated. |
 Vaughan
Mostly Harmless
Posts: 8334
Loc: Sydney, Australia
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Leopard
Member: TechNet
Skill: Advanced
Certified:
    
Tweet This Post!
|
In response to Valdrin
Or use the List() function to pull the related data into the parent table.
| Vaughan Bromfield
Sydney, Australia
Please post questions to the Forum, not directly to me. Back-up your files before making changes!
Whenever I hear the term "popular culture" I reach for my Iridium Q-36 Space Modulator. |
|
|
|
