data entry form for many-to-many

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

I think this is more of a forms question than design
question, so bear with me . . . .

I am designing a database primarily needed to manage our
relationships with community members. Since many contacts
relate to us in more than one capacity things can get
complicated.

I have a many-to-many relationship between a "Contacts"
table (PK=contact ID) and a table of contact types
(PK=contacttypeID). They are joined by a "relationships"
table with two fields (PK=contact ID + contacttypeID).

The problem is: how do I set up a primary data entry
form with a subform that allows me to mark multiple
contact types?

I cannot set it up properly to let me input new records
and select the various contact types for each.

Does this sound familiar? Please help.
 
Hi Andy,

If your main form is Contacts then you just need a subform for Relationships
with ContactId as the LinkMasterFields and LinkChildFields set to the
ContactId field. Typically this type of subform would be a form in
Continuous view.

You could get a bit fancier and use a pair of MultiSelect Listboxes - for an
example of this you can download my SelectRecords sample on
http://www.daiglenet.com/MSAccess.htm. It's just another way to deal with
data items that have a Many to Many type relationship.
 
Back
Top