Subform Multiple Entries

[Subform wont allow multiple entries]

Hi there!

I am creating a training database. I have 2 tables, One with "Employee
Details" the other with "Training Details".

I have created a "Form" in a justified template useing data from the table
"employee details" with the employees first and last name listed on the Main
Form.

I then created a "form" as a "datasheet" using the "Training Details"
listing training course name and training course provider.

I then created a subform on the first form that had employee details,
inserting the "training details" datasheet form as a subform.

I am only able to create ONE entry in the subform per employee. How do I set
it so I can have multiple entries entered in the subform? I am not confident
in relationships or anything like that so think this might be my down fall

Your help would be super appreciated

Have a great day

Bec

 

[KARL DEWEY]

You need a one-to-many relationship between the employee and training
details. The employee must have a primary key field that is matched in the
training details table as a foriegn key.