If Record Exists... Script?

[clrblue]

Is it possible just to write a script that checks that for every unique id in one db, there is a record created using that unique id in another? I just don't know the logic without being able to use a FOR loop or a WHERE clause. And I don't want to have to rely on user input. It would be super cool if the script would automatically run everytime that either db was opened or if a change was made to either.

TIA,

KC

[Keith M. Davie]

It seems to me that a relationship would be beneficial such that any script would check only those records which are not so existant.