>Hi Rick
>How have you been?

Hi Mike. I've been doing well overall. Ups and downs like everyone else. :-) How about yourself?

>I try to avoid edge cases. RECNO() only works in a query on a single alias. That's too limiting for me. If you don't have a good PK, you have to resort to weird approaches to get around that.
>A sequential GUID primary key is always unique to each table and across multiple tables and even across multiple systems. That's the widest possible application.

Agree. A good PK is essential. We have cases where a block of records in a table will be overwritten by all CHR(0) characters from time to time, and for those records we need a way to access them uniquely. By including the nRecno field in each record (in those cases only where we're doing data fixes), we can then generate auto-fix source code to update and re-populate the record, including the PK with its original value, as we have information stored in a journaling table. Comes in handy sometimes.