field cannot be updated

[Guest]

I'm getting the message 'field cannot be updated' when i try to input records.
I dont know if its a relationship or query problem. I have the following
tables:-
tbl_Employees
EmployeeID (pk)
Surname
Forename
Address
etc...

tbl_TrainingRecords
TrainingRecordsID (pk)
EmployeeID
TrainingDetailsID

tbl_TrainingDetails
TrainingDetailsID (pk)
Training Company
TrainingCourse
startdate
enddate
etc...

(Employees can take many courses run by many companies so there are tables
for courses and companies that are linked to a combo box )
Please can someone tell me the correct relationship format and query as the
course info is not the only thing that will have multiple entries for each
employee, ie there will be tables that include medical tests that are on
going, so there will be a list of same medicals but different dates etc..

 

[BillCo]

I'm willing to bet you were trying to update a form based on a
non-updateable query. not surprising that the query is non-updatabale
because what you have here is a many-to-many relationship.

tbl_Employees should be joined to tbl_TrainingRecords on EmployeeID in
a one-to-many relationship

tbl_Training_Details should be linked to tbl_TrainingRecrods on
TrainingDetails in a one-to-many relationship

i.e. employees are linked to tbl_trainingDetails in a many-to-many
relationship. - I'm guessing you didnt set this up?

anyway, how you chose to allow data to be inputted via forms could take
many different shapes - depending on what you need. Personally I would
recommend this:

One form tied to tbl_Employees - doing nothing but updating employee
records.

Second form tied to tbl_TrainingDetails where details of training
sessions are updated. It would have a subform tied to
tbl_TrainingRecords where you could enter the employees attending.
subform would have a combo box displaying employee names but linked to
employeeID - from your post i figure you may run into problems here.
Let me know how you get on.