Building Relationship: one to many

[Keeper]

I'm building a new db which tracks personnel (one table) and training events (second table). I've created an intermediary table which records which personnel have attended which training events. I'm having trouble figuring out how to build the relationships between these three tables. The key for Personnel is the last four of an individual's SSN. The key for Training is an event code. Both fields have been added to the Tracking table, along with a completion date.



One individual may attend multiple training events. Each training event may be attended by multiple people. Each individual may attend multiple training events on the same day. So I think this equates to:

Personnel - Tracking: one to many
Tracking - Training: many to many

Is this correct?

When I try to build the relationships, it always turns out as a one to one relationship, and I can't figure out how to change this. I'm using Access 2007, and it's been about 10yrs since I've built a db, so I'm learning from scratch.

[June7]

The relationship is many to many: each person can have many training and each training can have many persons. The unique ID fields in Personnel and Training have been set as primary key?

The junction table 'Tracking' has records that associate persons with trainings.

Person and training PK values can each occur many times in Tracking, however, each pair combination should be allowed only once (unless you want to allow training repeat then the date becomes another component of uniqueness). One way to enforce is to set both fields as compound primary key.