>SQL Server also uses INDEXES to have PK and Foreign keys. So yes VFP has real PKs and FKs.

OK... I looked around in VFP and found the difference between the index types in VFP: Regular vs. Primary vs. Candidate.

I've always used the Regular index type for everything. I bet if I go in and declare the right ones as Primary, it will push over the way I am needing it to.


I'll try it out.