Ann W. Harrison wrote:

>
> I'd have triggers on the reservations table ....

Thinking about it a bit more, I'd use gateway approach - relying purely
on triggers leaves the possibility of undetected simultaneous
inserts/updates that would not be detected.

The update of the gateway records should be in the same transaction as
the insert/update of the reservation records.

Regards,


Ann