Hi All,

Can anyone point me in the direction of either in Wrox's books or someone else's for a tutorial in a many to many unbound form.

One Complaint many complainants each of whom can make many different complaints is the model I'm working with.

Cheers

For a many to many relationship, you need a junction table. So this would be:

tblComplainant
CID
CFirstName
CLastName
etc

tblComplaint
ComplaintID
ComplaintType
etc

tblComplainant_Complaint
CCID
ComplainantID
ComplaintID
Date
Time
Notes
etc

This would allow one person to make many complaints. This would not allow many people to be involved in one complaint incident. Can you be more specific?

Why do you want the form unbound? Which would be the parent on the form, Complainant or Complaint?

HTH

mmcdonal

Look it up at: http://wrox.books24x7.com