the update statement is giving me an error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
and the insert statement error:
The multi-part identifier "Controlled_Checklist_Facility_Data.FAC_ID" could not be bound.