I am trying to copy the contents of a dbf into a second one from a network drive on to my PC so that users to not have to get out of the application (for further use using the code

SELECT * FROM (lcSourceFile) INTO DBF (lcSourceTempFile)

where

lcSourceFile     = H:\DATA\x
lcSourceTempFile = C:\Temp\Tx

I use a browse command to look at the two tables and find that table Tx has fewer records then table x. Two questions.

1. Why does table Tx have fewer records then table x?
2. What is the best way to find what records are missing?

The reason I am doing this is that in VFP 9 I added a field to the table. What I what to eventually do is file in the new field for another table which has the values for the additonal field.

I am posting this because search is not working at the moment so I do not know if this has been already answered.