>>>>can you expound on that method a bit?im more familiar with using Replace and SQL to populate my tables
>>>
>>>A cursor is a table which is stored in memory, and is typically used to store temporary data. Since you "Select into table Greater", I wonder whether Greater is a table used for permanent storage of data, or only temporary date?
>>>
>>>NB! If you hover the mouse over Message view setup in the upper right corner of this textbox, and select Enable auto quote, it's easier to answer your questions since the whole or parts of the earlier messages will be carried over to your reply.
>>
>>
>>if i use a temp table...i wont be able to index it will i?
>
>Use a cursor instead! And yes, you can have index tags on cursors. You usually create the cursor and the index tags in the load of your form. The easiest is to use a select statement

>Select * from yourtable where .f. into cursor yourcursor readwrite
>Index on whatever tag something

>Then whenever you want to select data into this cursor, you use what's usually called a safe select:

>Select from yourtable where somecondition into cursor curDummy nofilter
>Select yourcursor
>Zap
>Append from dbf('curDummy')

>If the data fills a grid, you issue Yourgrid.Refresh() afterwards.

ok i have a select * into cursor X readwrite
then index on fname tag fname

so if i have a stament like

THISFORM.UpdateResultsWindow('The name '+ test.fname + ' already exists in the Database')&& fname being the cursor will that work?

that worked for me when test was my addition table now its being a little troublesome

also its telling me no table order set for table
and pointing at
SEEK test.fname