Multiple names per row in table-How to print labels

[Dirk Miller]

I have my table set-up with company name, address, etc. with multiple contacts.
I'm trying to set-up a mailing label for selected entries via a form with
Check Boxes, and results are in a query. Seems to work fine in the query. But
i'm having a problem generating the Mailing labels when I have contact1,
contact2, contact3, etc. on the same row in the table.
ie. Company1 Company1 Company1
Contact1 Contact2 Contact4
Address Address Address
City, St, Zip City, St, Zip City, St, Zip
How do I proceed with this? Spent more than two days and am frustrated!

 

[Rick B]

If companies have multiple contacts, then you have a one-to-many
relationship. Each contact should have a separate record in a "contact
table. Then you can pull each record to a label along with the associated
company data. Not sure how you could do this with your table structure.



CompanyTable:
-----------------
CompanyNumber
CompanyName
MainPhoneNumber
Address
City
State
Zip
..
..
..


ContactTable:
----------------
CompanyNumber
ContactFirstName
ContactLastName
ContactPhone
ContactFax
..
..
..


Hope that helps.

Rick B

 

[Dirk Miller]

Thanks for the reply. I may have to change the table structure. I have at
least +500 entries of Companies with anywhere from one to seven contacts for
each company, and looking to add more. Thought that laying out the table this
way would save on space or size of DB. Still entertaining anyone with a
option.

 

[Allen Browne]

Rick is right. You *really* need to go with the relational structure, where
one company can have many contact people.

 

[Dirk Miller]

Okay, I give up. I'm in the process of redesigning the structure of the DB.
Thanks for all of your feedback. I was reluctant to do this but have
rethought it throuh and it makes sense to do it this way.

 

[Allen Browne]

Applause.