Printing labels with a portal?

[Valdrin]

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]

How are the two tables related?

Edited March 11, 2010 by Guest

[Valdrin]

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]

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]

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.

[Vaughan]

Or use the List() function to pull the related data into the parent table.