If it is only the RI code firing in B it should work. Really the RI code should
fire last. Try switch the A trigger from:
Try to switch the A trigger.
From:
__ri_insert_A() .AND. AddToB()
To:
AddToB() .AND. __ri_insert_A()
=========================
>>Is the trigger in B necessary if being fired based on the trigger of A?
>>If not, you might try place code in your B trigger to bypass if called from
>>the trigger of A.
>>==========================
>The trigger in B is generated by the VFP RI builder and really just checks that the FK value exists in the parent table . I'd rather not have to roll my own RI code, but if there is no other way...
>
>Rob