How do I show more than one contact type for a contact?

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

Guest

I am new to Access. I have downloaded the Contact Management template and am
hoping to tweak it to meet my needs. The main problem I'm having seems like
it should be very simple...but I can't figure it out! It lets you indicate
what "contact type" someone is (buyer, seller, friend, family, potential
client, etc....) But some people fall into more than one catagory, and it
only lets you choose one. I want tobe able to use this program to do
different mailings out to people, wheather it be business letters or
christmas cards. Can somebody help point me in the right direction?
I am using Access 2003.
Thank you!
 
You would need to add a new table to the database. Something like
tblContact_Category. It would hold the ContactID and the CategoryID. Maybe
even a start and end date... if you wanted to get real fancy.

Then, change the UI to have a subform that allows the entry of multiple
categories per contact.
 
Back
Top