Well we have sorted it out... sort of.
We believe we have found a bug in VFP and the only workaround so far we have found is to put an index on the nTableID column. Attached is a link to a ZIP file containing a test case that demonstrates this problem.
Does anybody know if this is a known bug or if it has been declared not a bug or something. Maybe someone from the Fox team could comment on this ?
Link to file:
DataProbTest.zipCheers,
Chris Ormerod
Have a nice day :)