T
tim
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..
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..