Many to Many Relationship - Data Entry

B

Barry Moses

I would greatly appreciate assistance to this question.


Intended result: List a member and add his practice sessions or list
a practice session and add the members that went to it. (I actually have
similar scenarios with 'training' and 'incidents'...like the practice table)

Tables:
Members
Practice
and a
"Junction Table"

I have the primary keys of Members and Practice in the Junction table. I
have the primary keys of those two tables in the Junction table set as
primary keys in that table.

How do I relate this information for adding the above information? Will the
actual data be added to
Members and Practice tables? What fields need to be in each?

Example:
I add members (with MemberID) to Members table.
I add practice sessions (with PracticeID) to Practice table.
I add those two Primary keys to the Junction table.
I create one to many relationships.

How do I connect a Member with Practice(s) and a Practice with Members.

Please advise (should be an easy one for you gurus!)...:)
 
L

Linda Burnside

Barry,

My suggestion would look something like this:

tblPractices tblSchedule tblMembers

MemberID ----------- MemberID

PracticeID ----------- PracticeID



Linda
 
S

Steve Schapel

Barry,

Just a hint for the future. If you really feel it is important for your
message to appear in more than one newsgroup (in practice, this is
seldom necessary), it is preferable to cross-post (i.e. address a single
message to both groups simultaneoulsly), rather than multi-post (i.e.
send separate copies of the message to each group). Thanks.
 
Top