Hello Akhan
I know how to do it from a SQL statment
select recno() as keyf, * ;
from yada yada ;
into table c:\temp\temp.dbf
index on key tag keyf
set order to tag keyf
hope this helps you
>Hello all
>
>I would like to set the recordnumber as the key field for the view ? how to do it any ideas.
>
>Thanks for any help