RECNO() is not reliable when SELECTing from multiple tables. This is documented in Help.Craig,
Actually I looked through the help documentation, the M$/KB and some printed references I have, but saw nothing about the results of a RECNO() when selected from multiple tables. Do you remember where you saw the reference.?
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.