>> >Technically that is what I'm trying to do however it has to relate to a
>> second table. Is this possible?
>> >
>> If you use RI and second table connected by UPDATE cascade trigger, foreign
>> keys of the second table will be changed too. To change something outside
>> primary/foreign key system you can run chain of UPDATE-SQL commands even
>> combining them under TRANSACTION for greater safety.
>
>I I remember correctly the original post also said something reagrding use of remote
>tables
>note that to do TRANSACTIONS for remote connection you have to use SQL passthroughs and
>BEGIN ...END TRANSACTION
>will no work
>
>Arnon
For remote table it's relevant to use transaction as part of stored procedure which will also include all UPDATE commands.
Edward Pikman
Independent Consultant