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