Combining Several Tables in to One Table

[NDD]

Did I do the value list correctly?

If I understand correctly, I need a third table named audit to tie it all together?

 

[NDD]

I have added all the topics and fields.

 

[NDD]

I'm still trying to learn to do this. I have built a completely different database and I think I'm ready to link them.

I have 6 total tables.

One is named Main - It has Name and other common information for each trainee.
Each table has:
1. ID (Auto number) (Primary Key)
2. Foreign Key (on the other five tables not main) each of these tables is a topic table containing fields for training subjects.
3. # - this is an administrative number I assign to each trainee. It changes as they move from group to group.

Right now, I have the ID on Main in a one to many with each of the Foreign Key Fields on the other five tables.

I need to make sure the training follows the trainee, if that makes sense.

Any suggestions?

 

[NDD]

Here it is.