Grid/Combo Box

[OldBitByter]

I have a grid that pulls up basic information about a facility. I want the user to be able to select the "Type of Facility" column and have a drop down combo that reads types of facilities from a second table. When the user selects the type of facility, I would like the combo to disappear and the grid to display the description of the facility type selected. The primary table has only a key field that relates to the type of facility table. The type of facility table has two fields, type_key and type_desc. I am having trouble getting this to display and update correctly.

Currently, the grid shows a combo box in each row. When I select a facility type in one row, it stays selected while I select a different type in another. This looks ok, but when I click on a different column, all the combo boxes change to the last facility type I selected.

Any suggestions?

Thanks to all,

Mike

 

[DEDMOD]

What sort of code are you using to get the description to display in the column? It may be that your code references the column value and that, of course, will be the last value you chose. If you post the code, probably someone will figure out where the problem lies.

Dave Dardinger

 

[PETO]

Have you worked with the SPARSE property ?