如何为可选的现有唯一键强制执行参照完整性？

We have multiple offices, and within each office there are multiple departments (some departments have employees in multiple offices). We have two existing systems that identify employees in different ways: in one, employees are identified by IDA; in the other employees are identified by IDB.We have multiple offices, and within each offic