Thanks, that's helpful guidance.
I wish the system were modeled in a way that let us do all constraint
validation within the database, but unfortunately it's not so.
--
This communication and any attachments may contain confidential information
and are intended to be viewed only by the intended recipients. If you have
received this message in error, please notify the sender immediately by
replying to the original message and then delete all copies of the email
from your systems.