Mark,
No one else has asked yet, so I'll broach the subject. Why the heck do you want recno anyway? It's usually more appropriate to use the primary key for each row.
>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.