Autocreate new dataset in connected table?

[Hyoryn]

Hi,



I have a Table with employee information (EmployeeID, name, adress, etc.) and another table for annual/monthly trainings each employee has to receive. I split these two mainly for clarity (there are over 30 trainings).

Both tables have the employee ID as the primary key and connected 1-to-1.

I created a form to add a new employee to the primary table and now i want this form to also create a new dataset in the trainingtable (just create a new row with the EID, since all the training dates are added later in a different form).

Making the connection referential and using auto-update doesnt work for some reason.

Is there a way to do what i want? I really dont want to merge these to tables into one, because it is a lot of data and would get very confusing.

I hope you guys can help me

Hyoryn

P.S.: as you can probably tell english isnt my native language and i use the german version of access, so i might have gotten some of the terms wrong, sorry about that

[CJ_London]

Both tables have the employee ID as the primary key and connected 1-to-1.

from your description, it sounds like your data has a many to many is not normalised. I would expect three tables

tblEmployees
EmployeePK autonumber
EmployeeName text
...
...

tblTraining
TrainingPK autonumber
TrainingDesc text
...
...


tblEmployeeTraining
EmployeeFK long - link to tblEmployees
TrainingFK long - link to tblTraining

[Hyoryn]

Thanks for the reply.

I'll try it once i get home. I'm rather new to access and theres still a lot to learn

Thanks again