>Select * into table addition >index on fname tag fname > >SET ORDER TO tag fname >All this needs to be done BEFORE you start working with the greater table. You can do it in the Form Load or Form Init method (probably others as well)
>SCAN >SEEK addition.fname &&check for nameIn your code yor are scanning all records in the Addition table looking for names in the Addition table. This makes no logical sense. You need to pay much closer attention to what tables you are processing and what values you are looking for. What you need to substitute is (in the click event of the button the user presses
SELECT addition SEEK greater.name > IF FOUND() > THISFORM.UpdateResultsWindow(fname +'already exist') > ELSE > thisform.updateresultswindow(fname +"added') > Thisform.continue&&(this form has the code to send the name to the greater table) > ENDIF >ENDSCAN >>