I have a local view defined like this:
SELECT PrimaryKey, ForeignKey, Amount, Foreign.ForeignCode FROM Primary INNER JOIN Foreign ON Primary.ForeignKey = Foreign.ForeignKey
All fields except ForeignCode are updatable.

It is table buffered in use; a grid displays ForeignCode and Amount textboxes, and there is ForeignCode combobox and Amount textbox outside the grid for editing/adding records.
I want to refresh the grid to show changes to the ForeignCode and Amount.

Everything works normally for the Amount textbox oustide the grid. The combobox.click REPLACEs both ForeignKey and ForeignCode in the view. Scrolling through the grid, the combobox shows the new values, but the grid values are still the old values. Refreshing the grid doesn't help, and requerying will discard the changes. Help?