How to make a labels layout
5 posts
• Page 1 of 1
Posts: 14
Joined: Tue Feb 09, 2010 3:52 pm |
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!
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
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 John Sindelar
SeedCode |
Posts: 14
Joined: Tue Feb 09, 2010 3:52 pm |
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. |
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
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>>
John Sindelar
SeedCode |
Posts: 14
Joined: Tue Feb 09, 2010 3:52 pm |
Ok, I see the difference between Address and ContactAddr now. It works!
Thanks. |
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests