PSSMargaret
Registered User.
- Local time
- Yesterday, 22:26
- Joined
- Jul 23, 2016
- Messages
- 74
Requesting advice on setting up a table/relationship.
The database contains Contacts and Communications that are sent out to contacts. I believe it’s a many-to-many relationship (a communication can go out to many contacts and a contact can have many communications).
So I’ve set up
The junctions tables I've done in the past only had two separate ID fields. This would have the two ID plus the four fields above in blue.
Any guidance is appreciated.
The database contains Contacts and Communications that are sent out to contacts. I believe it’s a many-to-many relationship (a communication can go out to many contacts and a contact can have many communications).
So I’ve set up
- tblContacts – contains ContactID plus a number of other fields regarding a contact
- tlbCommunications – contains CommunicationID and a few other fields that describe the Communication
- tblJctCommunications – junction table that contains ContactID and CommunicationID
- ContactID – already in tblJctCommunications
- CommunicationID – already in tblJctCommunications
- DateCommentReceived
- CommentReceived
- ResponseDate
- Response
The junctions tables I've done in the past only had two separate ID fields. This would have the two ID plus the four fields above in blue.
Any guidance is appreciated.