I knew the GridKing wouldn't be able to resist a reply! :-)
>You need to add "INTO CURSOR myColumnXComboSource" to your SQL:
>"Select * From destinations Where destinations.receiver = gridalias.receiver >INTO CURSOR myColumnXComboSource"
Won't this confuse VFP? Will this try and create a new cursor for each line on the grid? What happens for all the other lines in the grid apart from the currently selected one?
>You will need to add to your Grid.AfterRowcolChange():
>this.column5.combo1.Requery() && assuming that the combo is in column 5
>this.column5.combo1.Refresh()
>this.column5.combo1.ListIndex = 1 && so you see the first combo item right away.
I know ;o( It needs doing generically for any/each column which has a Combo
>You might need to change this sample code as you adding the combos on the fly >and I don't know if they always supposed to be in the same columns.
I hate to think what the performance impact will be on a large table... only one way to find out... - Hi Hoooo
Cheers
Will
Will Jones