Hi, I'm inserting records from one table into another, but I only have to insert those record that aren't in the destination table. Now I'm doing it like this:
Select Table1
Scan
lnId=Table1.Table1Id
If !Seek(lnId,"Table2")
Insert Into Table2 (id) Values (lnId)
EndIf
EndScan
Is There any easy way?, for example a combination of Insert and Select
Thanks.
Luis Navas
I never forget a face, but in your case I will make an exception :-)