Ok, now it makes sense, sorry I am but a lowly noob, ha. Are there any workarounds or am I SOL?

Thanks for the help.

ag_id is the PK for table agenc, but not for agency_deplo_plan

I tried

update dbo.agency_deplo_plan

set ag_id=agenc.ag_id

but I get the error:

The multi-part identifier "agenc.ag_id" could not be bound.

Does it matter that i left out ag_id from that query? Also, it doesn't contain any NULLs, so why would SQL Server have a problem with it?

I know which is confusing to me. I'm running an auto update utility provided by my company, so maybe it is a stored procedure?