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!!