I have a view based upon two tables, related by a field.

If I change the value of the linking field, and issue a refresh(1...), only the data from the primary table is updated, the related table values are not. The VFP documentation states:-


REFRESH( ) returns the number of records refreshed.

The records are refreshed with data *from the tables* from which the SQL view is created. Records are refreshed in the SQL view open in the currently selected work area.

(My emphasis)

Issuing an requery() does perform the update but...what am I doing wrong with refresh?