David,

Yau write:
.... data entered by the 1st user can be seen (through a click of a search button that pops up a separate form using default data session that does a sql query to retrieve records from the base table of the transaction file) by the second user
...

Then the buffering is unimportant, because if the data is on the buffer of the 1st user,
never query can show them to the second one.

Why the second user can see the new data inserted by the 1st ?
Because the query scan the table without use the cdx index.


however, once the document number is retrieved by this search screen to the transaction screen, the new record cannot be retrived by the transaction screen of the second user


Why the second user can not load the new data inserted by the 1st ?
This because this use the cdx index,
but the new record inserted by the 1st user it is remained in the VFP buffer of the index
(it is not flushed into the cache of the OS).
My first message show this fact; in fact, the ADIR() read the data by the
OS cache !

This is the reason for which, in the other message, I have written to you that what you have written is not correct.

Fabio