>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?

Robert,

You are doing nothing wrong with refresh. The help states that refresh updates the view from the tables, not the other way around. Requery() force a recreation ofthe view and has an implicit TableUpdate() in it. You should probably be doing an explicit TableUpdate() to write the view's changes to the tables before you Requery() or Refresh() the view.