>>>>When you add VFP based RI, it adds bad code as triggers to the DB. You can check it also when right clicking on the database and looking at its code.
>>>>
>>>>I said bad code, because it's too verbose. There are alternatives and we used one a while back.
>>>
>>>As far as "verbose", I don't mind as long as it works reliably. And what was the alternatives you used?
>>
>>In 2005 I started from Doug Hennig RI builder, but then modified it to suit our needs. I think I've posted it here.
>>I'm not sure, though, if my former colleagues still use it or switched back to VFP RI. I know they are now switching backend to SQL Server, but I haven't spoken with my former colleagues for some time. May be it's time to check up how they are doing...
>
>Thanks. I will start with the VFP RI and see how it works. I am also rushing to get my app to work with the SQL Server so that I don't have to worry about VFP RI.

I don't recall 100% now, but I think VFP RI don't allow NULLs in the FK values and this is the main difference with SQL Server. Although I suggest you to test to be sure.