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

How are the two tables related?

Edited March 11, 201015 yr by Guest

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.

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.

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.

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