We are trying to figure out how to create and print labels for a party where the Labels will be name tags. We are using a label that has two columns The difficult part is that each person can have a guest and we want the person's first and last name on the left label and the guest name on the right label. The labels we plan to use have two columns. Is there a way to have the label builder print the first and last name on the label in the first column and then related data in the adjacent label on the right. So the left label would be the person and the right label would be the guest or blank if there were no guest. Also the Person data is in one table and the guest data in another table which is related with the person's ID.
simple representation of the data
Person
ID
FirstName
LastName
Guest
ID
Person_ID
FirstName
LastName
It would be nice if there was a way to have the report operate on the person table and then for the next item pull the guest. So all the first column would be entries from the Person table and the second column would only be entries from the Guest table if there was any related.
Please let me know if you have any ideas how we could accomplish printing this data and keep it organized with a person and their guest. The table allows more than one guest but for this event it should just be 1 or 0 guest per person.
Thank you,
Todd Isaacs
Printing Labels with Related Information
Re: Printing Labels with Related Information
Hello.
Such report could be done using master-detailed report where detailed will be on the Panel.
Please, look at the attached report template:
Thank you.
Such report could be done using master-detailed report where detailed will be on the Panel.
Please, look at the attached report template:
Thank you.