designate primary address in Access record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a form in Access to enter contact info.

How can I designate, at point of data entry via the form, which of the
contact's addresses (home or business address) is "primary" or "preferred"
for printing labels for say a mass mailing? Is there a way to set one group
of fields up as the "default" address for this contact?

Can I group all of the "home" fields (e.g., homeaddress, homeaddress2,
homecity, homestate, homezip) and designate that group as the contact's
preferred mailing address? Or do I have to set up check boxes for each field?

Thanks!
 
if one contact may have multiple addresses, then you should have a minimum
of two tables: tblContacts (parent table), and tblContactAddresses (child
table), with a one-to-many relationship (one contact may have many
addresses, but each address belongs to only one contact). example:

tblContacts
ContactID (primary key)
FirstName
LastName

tblContactAddresses
AddressID (pk)
ContactID (foreign key from tblContacts)
Address1
Address2
City
State
Zip
Primary (Yes/No field)

the standard data entry setup for a parent/child relationship is with a main
form (tblContacts) and a subform (tblContactAddresses). when entering an
address for a contact, in the subform, simply put a checkmark in the Primary
checkbox (checkmark = Yes) if that address is the primary or preferred
address.

when querying tblContactAddresses for a mailing list, simply set a criteria
on the Primary field, as

Primary = True

the query will return only the addresses that have been designated as
primary.

hth
 
Back
Top