Many to Many Problem

[Novice1]

I have three tables:

1. Training Table: EventID with other fields
2. Junction Table: EventID and TraineeID
3. Trainees Table: TraineeID and other fields

I established relationships (one to many) from the training table to the junction table and from the trainees table to the junction table.

I built a training input form. From the query I added EventID from the training table along with some other fields from the same table. I added a subform to add the list of trainees.

Everything works fine except if I add a training event with multiple people, the training entry in the form is multiplied by the number of trainees. For example, if I have one training event with three trainees, then the event appears three times in the form.

I tried using EventID from the junction table (instead of the Training Table), without luck. Any ideas what I'm doing wrong?

 

[arnelgp]

eventID should be in the main form, while traineeID and eventID (from junction) in subform, create a Link Master/Child link using eventID in main form and eventID in subform.

 

[Novice1]

Thank you. I added EventID to the Trainee table and recreated the link. It worked. Thank you for the info and the quick response.

 

[Alvarogue]

Goodness! so the way to make Many to Many is establishing 2 relationship of one to many and the middle table to be the Many to Many?