Views only use primary keys if they are updateable. They use this in the SQL update statement that runs behind the scenes when you do a TABLEUPDATE().
>Carla,
>
>You could try adding a field to the view like RECNO() AS RecNum then setting RecNum as the primary key. I think, however, that you need a primary key to use a view. Views use SQL commands and SQL commands don't work reliably with the record number.
>
>>I need to define a View from a table That do not have a primary Key. How can I define the Recnum number as primary key, because this unique.
>>
>>
>>Thanks
>>Carla
Erik Moore
Clientelligence