This one has been dogging me for years in one form or another. I go into a form, run a SELECT and new records appended by another user are. Go out of the form, go back in, on and on and on. In some cases I need to quit the program to make the new records show up.

I can fix the problem by moving the record pointer in the table(s). A simple

SELECT MYTABLE
GO TOP
SELECT * FRO MMYTABLE

makes all of the data appear all of the time. GO RECNO() has the same effect as does anything that moves the record pointer. I realize that this has to do with local data and index caching and is part of the reason that VFP is so fast, but there must be a less klunky way of handling this.

SET REFRESH has no effect.

Did I miss some setting in VFP somewhere that would make this problem go away?

Mike