Hi Dave, thanks for your reply.

What I want is prevent updates, inserts if there is value of true associated with a foreign key already.

I managed to resolve the problem and...