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

From: [MVP] S.Clark (steve.clark_NOSPAM_at_FMSInc.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 10:03:57 -0400

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. 

-- 
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
"Erika" <Erika@discussions.microsoft.com> wrote in message
news:A0341DC4-E78E-4640-BF67-F9A053CC92F2@microsoft.com...
> 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!
>

Relevant Pages

  • Re: Composite DatakeyField?
    ... DataList so i got ProductID in one column of List and CategoryID in another ... where are the keys defined on the database side or the ... >> As Composite Key concept says that there can ...
    (microsoft.public.dotnet.framework.adonet)
  • Simple query - broken brain.....
    ... can't seem to conceptualize the proper way to go about getting the proper ... SELECT ContactID, CategoryID ... WHERE CategoryID Not In ... I know my query is "wrong" but how do I write to display what I'm trying to ...
    (microsoft.public.access.queries)
  • Re: Kategorien/Mehrfachnennung
    ... >ContactID ... >CategoryID ... Am Besten mit einem Unterformular welches ...
    (microsoft.public.de.access)
  • Failed insert query
    ... I'm trying to port some data from one database table to another ... WHERE Exists (SELECT ContactID FROM newdatabase.dbo.contacts) ... INSERT statement conflicted with COLUMN FOREIGN KEY constraint ... ContactID) and the contactsevent (foreign key ContactID) table. ...
    (comp.databases.ms-sqlserver)
  • Re: database design question
    ... has projectID and ContactID fields in it. ... proper table design for the database. ... If I build separate tables for each contact role ...
    (microsoft.public.access.gettingstarted)