Thanks Hugo,

I know that the example looks a bit strange. Basically, one table is
owned and controlled by not only another application but another
organisation (our service provider). The way of integrating my
app/table (which is hosted by the service provider) and theirs is by
linking these tables. The natural thing would be to use referential
integrity between the tables, but for commercial/political reasons,
they need to be "galvanically separated." I would rather try to
convince them to put a trigger in place rather than me having to write
an application which does the syncing of the tables.

Sincerely,

Nils