David,

Whatever you mean sounds interesting and important. Please explain more fully what you mean.

I have done multitable SELECTs where of course I could not use one of the RECNO() to order things, yet obtained results ordered as I wanted them, (in the original order of one of the tables) without fully knowing why.

Alex


>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.