Newbie and many to many relationships

  • Thread starter Thread starter Barry Moses
  • Start date Start date
B

Barry Moses

I would greatly appreciate assistance to this question.

Intended result: Either list a member and all his practice sessions or list
a practice session and all 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 display? Is the actual data 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!)...:-)
 
answered by another person in another newsgroup (m.p.a.modulescoding) where
you posted this same question
 
Back
Top