Hello,

i think in VFP 9 you can do

INSERT INTO Transactions FROM (SELECT * FROM otherTable WHERE NOT EXISTS (SELECT primaryKey FROM Transactions WHERE Transaction.primaryKey = otherTable.primaryKey))

in current versions you may just use ..

SELECT * FROM otherTable WHERE NOT EXISTS (SELECT primaryKey FROM Transactions WHERE Transactions.primaryKey = otherTable.primaryKey) INTO CURSOR missingRecs

SELECT Transactions
APPEND FROM DBF('missingRecs')

Regards

Christian