>Mark,
>
>I have a question related to Valentin's combo in grid.
>
>What if I want the combo box use different cursors which depends on the data in other column?
>
>For example, I have 2 columns of grid, item, supplier. The supplier column is a combo box. When item has default supplier(s), the suppliers' id should be shown in combo box. If item doesn't have default supplier, the combo box should be filled with vendor id.
>
>Please take it slow, if you will.
>
I do not understand why you use a combo box for the supplier/vendor because it looks to me this is a value that you would not allow your users to change. The value is based on the actual item.

Regardless, in a grid, what you are wanting to do could be a problem because the grid displays multiple records that have different values for the item and supplier/vendor. You can only do this with a relation between the item + supplier tables and item + vendor tables. This could probably be done with a parameterized view, and I am almost certain it will require a SQL Union among other things. I am going to place a little faith in more seasoned members here on the UT to hopefully help with this. I suggest you post a new thread with this specific question including details about the tables and example field names involved.