|
Subject:
|
Unbound Forms
|
|
Posted By:
|
jeremy1048
|
Post Date:
|
7/28/2008 10:36:11 AM
|
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
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
8/4/2008 1:26:21 PM
|
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
|
