R
Ricter
Three tables: tblEmployees, tblFunctions, jctEmpFuncs.
One main form: frmEmployees with subFunctions.
Two one-to-many relationships, tblEmployees > jctEmpFuncs & tblFunctions >
jctEmpFuncs. Both relationships are full integrity, cascade update & delete.
Adding an employee & functions, or adding functions to an existing employee
works fine, the jct table is being updated properly.
However, I can go to a new employee record and add a function without adding
an employee. After leaving this new record, it is not saved, except, the
function IS being added to the jct table without a corresponding employee.
How can I fix this?
Thank you
One main form: frmEmployees with subFunctions.
Two one-to-many relationships, tblEmployees > jctEmpFuncs & tblFunctions >
jctEmpFuncs. Both relationships are full integrity, cascade update & delete.
Adding an employee & functions, or adding functions to an existing employee
works fine, the jct table is being updated properly.
However, I can go to a new employee record and add a function without adding
an employee. After leaving this new record, it is not saved, except, the
function IS being added to the jct table without a corresponding employee.
How can I fix this?
Thank you