-- Update foreign key constraint to link to client_link instead of client table, client_link must exist 
alter table RESIDENTIALITEMSCAN
  drop constraint RESIDENTIALITEMSCAN_CLIENT_ID;
alter table RESIDENTIALITEMSCAN
  add constraint RESIDENTIALITEMSCAN_CLIENT_ID foreign key (CLIENT_ID)
  references CLIENT_LINK (CLIENT_LINK_ID);