Design questions - 10-04-2004 , 03:13 PM
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?
Re: Design questions - 10-04-2004 , 03:41 PM
company name on your label, grab it via a relation.
Re: Design questions - 10-05-2004 , 03:53 AM
On Mon, 04 Oct 2004 16:13:13 -0400, G.Miller told us that:
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.).
Re: Design questions - 10-05-2004 , 08:58 AM