I have a grid with a few columns where I'm having a problem with the (desired) refresh of two of the columns.

The column has a group-ID in it, and the user can change it (as a combobox, but I use sparse=.T. so that the drop-down arrow only appears when the cell has focus).

The grid's cursor has a relation set to another table, where there are other fields from the group-ID. Two of these fields (name and phone) appear as adjacent columns in the grid. When the user changes the group-ID, I'd like columns with the group-name and group-phone to change as well. However, this doesn't happen (unless I move the record off the screen and then return to it).

What am I missing?

Thanks