The client confirmed that multiple records on the foreign tables related to the same record of the master table is not normal. So, they are working on fixing that right now. In the mean time, I removed those records from the table, for testing purposes, from the test environment, and I was able to have the option working ok. What is interesting here is that SQL Server detected something that VFP was not capable of. This is how we discovered that we had some bad data.