>>A little off the subject...Be aware that I had to correct the RI code for cascading deletes ( a bug verified by MS) when using SQL delete/insert updates
>
>What kind of bug? AFAIK, RI has problems dealing with compound keys, but surrogate keys should work Ok.
If you set the SQL delete old and insert new update method, VFP currently deletes child records. I had to put a patch in the stored procs (delete trigger) to correct this. It is a real pain that I have to remember to save my changes if I have to rebuild the stored procedures, as VFP will overwrite my changes..