>
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,
This is from the VFP 6.0 help file under SELECT - SQL
"Be careful when using, in join conditions, functions such as DELETED( ), EOF( ), FOUND( ), RECCOUNT( ), and RECNO( ), which support an optional alias or work area. Including an alias or work area in these functions might yield unexpected results. SELECT doesn't use your work areas; it performs the equivalent of USE ... AGAIN. Single-table queries that use these functions without an optional alias or work area will return proper results. However, multiple-table queries that use these functions — even without an optional alias or work area — might return unexpected results"
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer