>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?
Since it's a related table, you may need to shake it a little to have Fox understand that it needs to move the record pointer in the related table. One of "skip 0 in (this.parent.parent.recordsource)", "goto recno({same alias here})" should do that - and the good location for this command would be in the end of the combo's .lostfocus() (if you already have some code there), or in the grid's BRCC (but no .parent stuff then).