I am running fm6 on mac osx.

I am attempting to redesign a single table (single file) database I have
which contains company info and contact info. Currently, if there is more
than one contact for a company, a duplicate record is created and the
contact info is changed.

I want to change the database to a two table database. ie. companies and
contacts. I set up each company with a unique number in the companies
database and created a relationship for the contacts.

Once complete, I need to print out mailing labels for all the contacts for
each company for a given set of companies that I find by zip.

How do I set up the labels for printing? Do I have to print them from a
layout in the contacts database or can I somehow set it up to print labels
from a layout in the companies database?

Thanks,

G.Miller

G.Miller wrote:


Use the database which has the address information. If you need the
company name on your label, grab it via a relation.

On Mon, 04 Oct 2004 16:13:13 -0400, G.Miller told us that:

Set up your companies file to hold all general address info, and your
contact database to hold specific info for that contact, such as
Department, internal address codes, phone extension etc.

Setting up your mailing labels in the contacts database would be the
easiest. Do your search from "contacts" as well. Put a related field on a
layout ("Companies::zip") in your contacts database and do a search on
that. That will find all contacts within the zip range, which is what you
want. Take the address info on the label either from the companies file
(general address info) and the contact file (department etc.).

Regards,

Peter

"Peter" wrote:

Thanks for the insight.

Most welcome.

Peter