>>Oh I like this myself!
>>SELECT RECNO() AS myfield
>>
>>Is that what you mean Kia? That's an interesting approach I have never considered before.
>
>Roxanne, check out some other recent threads on Recno() in SQL-Selects. It's only reliable when you are working with a single table.
>
>Barbara
Yes, thank you, I've been keeping an eye on them becuase *IF* they did work it would make my non-normalized environment much easier to manage.
BTW, I just tested using RECNO() as a column in a 2 table SELECT and the RECNO() values got out-of-whack for a table that had index tags. But after DELETE TAG ALL on that table it worked fine. Oh well, guess I'm still stuck with multiple field index keys and fast-approaching grey hair. :D)
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos