Print multiple names on rolodex card

[vmon]

I have a company table with address information. I also have a contact table related to the comapany table. I want to print a card per company and want all of the contacts to print on card with their company. How can I do this?

Thanks,
vmon

 

[nonturbo]

First write some queries that show all contacts for company X. Then, once you can view all of the contacts, check to make sure you can easily change X to Y to view a whole new set of contacts/company. I'd attempt to help more, but you really didn't provide enough information yet. Once you've got the query written, then basing your report recordset on that query should give you the results your looking for.

SELECT * FROM Contacts WHERE CompanyID = X

Depending on how youre going to be printing/displaying these forms you might need to create a small form to pass the X variable to the report/query. Hope that helps...

 

[vmon]

Sorry for limited info. I want to print a report in the shape of a rolodex card and I want data to be like this. There is a 1 to many relationship between them and there may be as many as 8 contacts. Company(red) data is on left and contact(blue) data is on right.

The Acme Company John Doe - (123) 222-1111
1234 South Street Larry White - (123) 333-2323
Anywhere, CA 12345 Pete Jones - (123) 111-2929
Joe Person - (123) 222-2392