SELECT * FROMMasterWHERECode NOT IN (SELECTCodeFROMGroup) INTOCURSOR tmp
SELECTGroupAPPENDFROMDBF("tmp")
VFP8
INSERTINTOGroup ;
SELECT * FROMMasterWHERECode NOT IN (SELECTCodeFROMGroup)
HTH
I am not the most powerful man in this world. I am not the worst man in this world either. I just as same as all of you. I still need to learn from my mistakes...