Re: Using Checkboxes on a Form

you need a second table for the addresses, that way you can have as many
addresses as you want for a contact, your other option is to add alternate
address fields to your first table giving you the option to have one or two
addresses for a contact. The first option is definetly the correct way to
handle it.

"aaa2876" <amy2876@xxxxxxxxxxx> wrote in message
news:1181947685.921937.121380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello everyone!

I am in the process of setting up a client contact database for my
office and I have run into a bit of a snag. The database I have allows
for one address per client but some of our clients have two that we
will use - one for home and one for work.
Problem #1 where do I add in the fields for a second address - in the
Contacts Table that is already established or a separate Table?

We also would like to use these addresses to send out Christmas cards,
but some cards we would send to the home address and some we would
want to send to the work address. Instead of creating a separate
database for the Christmas card labels I would really love to just use
what I have.
Problem #2 If I have the fields available on one form to enter two
addresses, I would like to use a checkbox so that whoever is entering
the data can check off which address should be printed on labels for
our cards.

Problem #3 If I have checkboxes on the form, how do create a query
that would pull the address information that was checked off?

Problem #4 How do I create labels if I have two fields for Names,
addresses, city, state, etc...??

I am basically a beginner at Access, but I have taken some courses and
know my way around somewhat. If you have an answer for me I would just
ask that you be as specific as possible. I hope I have asked my
question as specific as possible, but if you need more info, please
ask me!!

Thanks in advance for all your help!!



.

Relevant Pages

  • Using Checkboxes on a Form
    ... I am in the process of setting up a client contact database for my ... We also would like to use these addresses to send out Christmas cards, ... database for the Christmas card labels I would really love to just use ...
    (comp.databases.ms-access)
  • Re: Using Checkboxes on a Form
    ... I am in the process of setting up a client contact database ... labels I would really love to just use what I have. ... save the addresstype number as a ...
    (comp.databases.ms-access)
  • Re: Mail Merge query
    ... I have a database of names and addresses which I am using to print labels ... Address your Christmas cards in copperplate, ... I know their surnames, it's just that there are at least two surnames in ...
    (uk.people.silversurfers)
  • Outlook mailing labels
    ... In preparation for the forthcoming festive season, I thought it would be a ... good idea to use the contacts file in Outlook to print address labels for the ... Christmas cards my wife is wont to send to all our friends. ...
    (microsoft.public.outlook.general)
  • Re: Mail Merge query
    ... I have a database of names and addresses which I am using to print labels ... I've got round this by putting a comma in the Last Name field but this is ... Address your Christmas cards in copperplate, ...
    (uk.people.silversurfers)