>I have an updateable local view. When I append a record to the view RECNO() is returning a negative number.
>
>What causes the RECNO() function to return negative numbers?
Adding a record to a view results in a negative number, since it isn't part of the underlying table until it's been committed to the table via TABLEUPDATE(). Once it's committed to the table, a valid record number will be assigned.