D
Desert Bear
I have 3 tables, related one-to-many with referential integrity
tblPeople, tblVersion, tblTasks
I have an update query which copies tblTasks.* when it matches [Forms]![frmPlan]![cboVersionSelect] and [Forms]![frmPlan]![cboSelectName].
I'm getting key violation error messages.
What is the fix?
tblTasks has the ID from tblVersion which has the ID from tblPeople
tblPeople, tblVersion, tblTasks
I have an update query which copies tblTasks.* when it matches [Forms]![frmPlan]![cboVersionSelect] and [Forms]![frmPlan]![cboSelectName].
I'm getting key violation error messages.
What is the fix?
tblTasks has the ID from tblVersion which has the ID from tblPeople