>I do not know what is the SELECT statement looks exactly, but I will try to imagine it...
>
>Remember that if you use table in the SELECT statement, and table is bufferent, only phisical data are used. Buffered data are not used in such case, so if first checkbox was checked, but in buffered table another logical field is true, SELECt statement will get the first value (that is on disk), it will not get the value from memory (buffered).

I didn't know that! At least neither VFP nor I are going crazy. Thank you.

>In your case, in the click of the checkbox remember the ID of the record in certain property on the form as it is the ID of the record for which that logical field is True. Than in the SELECT statement get record data using that ID value as a parameter for the query, instead of joining the optimistic buffered table.

Thank you.

Alex