Don't do it. The record number will change as the table is packed. Also, the record number is not reliable if you join multiple tables. You should be using a primary key instead.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer