SeedCode Support Forum

I need to make an Avery label printing layout. I'm using the Address table as the source, how do I get the Firstname and Lastname to appear in the layout? If I try to paste those fields in I get an unrelated table error. Thanks!

Select the contacts table related to address (switching tables is at the top of the field selector when you double click a field in layout mode).

Hope that helps,

John

All I get is <Unrelated Table> in my labels. They look like this...

<<Contact::ContactNameFirst>> <<Contact::ContactNameLast>>
<<AddressStreet>>
<<AddressStreet2>><<AddressState>>
<<AddressZip>><<AddressCountry>>


I can make labels either with the names or with the addresses but can't get both data on one layout.

Do I have to link the Address table and the Contacts table somehow? Sorry I'm not following this.

It depends on where the address fields are in your solution: if the address fields are in the contacts record, then your address fields would look like <<Contact::AddressStreet>>. If they're in a table related to contacts you'd use that table occurrence name, ContactAddr in this example: <<ContactAddr::AddressStreet>>

Ok, I see the difference between Address and ContactAddr now. It works!
Thanks.