>"Baby steps" :))))))
>
>I'm thinking at the end of the day you may have the program working! Congrats.

thanks!
but one more thing

Select * into table addition 
index on fname tag fname

SET ORDER TO tag fname

SCAN
SEEK addition.fname   &&check for 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

Now when i have this it works as expected it tells me the name already exist because the addition table was just fed the name in the SQL.

Select * into table addition 
index on fname tag fname

SET ORDER TO tag fname

SCAN
SEEK greater.fname   &&check for 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

This on the other hand...should but doesnt work, i cant imagine why it wouldnt (only thing different is my seek)
im trying to check in the greater table for the name and if it dont exist i add it with the else.
It doesnt error out but it shows (_____added) and it doesnt get added i also noticed it doesnt show the name either