At 20:36 12/01/2005, you wrote:

>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

What's a gateway record?

TIA

Tim

[Non-text portions of this message have been removed]