Adding records to a table automatically.

[readingr]

I am quite new to the whole access database thing. I've done most of what I need to do but I'm stuck on this:

The three tables I am working with are attached.

As you can see in tblcadetdayacti vity there are two fields. In its table they are drop down combo boxes.

What I need to do somehow (I don't really mind how) is add mulitple cadets for one activity at once.

I.e. Add the all cadets to do activity one in the dayactivity table.

I'm new to all of this so could you please point me in the right direction. I've tried to use queries but they havn't worked :(

Thanks.