A
allie357
I am trying to clean up a previously built database and normalize it.
I made a table with employee names and a primary key autonumbered
Violator_ID.
Now I wanted to run an update query to add the Violator_ID to the
Violations table. When I run the query below it says it updates zero
rows. The relationship between the tables will be one to many.
UPDATE tbl_Employees INNER JOIN tbl_Violations ON
tbl_Employees.Violator_ID = tbl_Violations.Violator_ID SET
tbl_Violations.Violator_ID = [tbl_Employees].[Violator_ID]
WITH OWNERACCESS OPTION;
Any suggestions on how to fix this?
I made a table with employee names and a primary key autonumbered
Violator_ID.
Now I wanted to run an update query to add the Violator_ID to the
Violations table. When I run the query below it says it updates zero
rows. The relationship between the tables will be one to many.
UPDATE tbl_Employees INNER JOIN tbl_Violations ON
tbl_Employees.Violator_ID = tbl_Violations.Violator_ID SET
tbl_Violations.Violator_ID = [tbl_Employees].[Violator_ID]
WITH OWNERACCESS OPTION;
Any suggestions on how to fix this?