>In multitable selects functions like recno() even with an alias aregument are not going to work all the time. Just make your result set the primary key field.
David,
Thank you. That sounds like it would work.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.