>>>Yes, you are correct. I am reading the VFP help and that the Persistent relationship has to be established.
>>>
>>>But let me, if you don't mind, as you another question. Do I understand correctly that after I build the persistent relationship and build the RI the code in the database will be something like this (pseudo code):
>>>Use Table1
>>>update Table1 set FieldA = cSomeValue where FieldA = cOldValue
>>>and son on for other tables?
>>>
>>>I am just trying to have a sneak preview of what the resulting code will look like.
>>>
>>>Thank you.
>>
>>You will get something like
>>
>>ri_insert()
>>ri_update()
>>ri_delete()
>>
>>in the trigger's fields in the database. The trigger's code will be in the code in the Database (you'll see it when you do Modify Code).
>>
>>It will be a lot of procedural and quite complex (in terms of verbosity) code.
>>
>>You can alternatively look into Downloads section here to get somewhat cleaner code and easier to maintain/understand.
>>
>>This is if you go with Doug Hennig's code. I think Walter Meester also has a Downloads here.
>
>Thank you.
Glad to help.
If it's not broken, fix it until it is.
My Blog