19th December 08:51
Populate combobox in datagrid dynamically based on previous column
I need urgent help on Windows Form datagrid. I have to Display a datagrid
that has a textbox column and another one combo box column. I have two tables
in my Access database as:
Columns: Part_ID, Descr
Here Part_ID is Primary key.
Columns: Part_ID, Part_Functions
Here Part_ID refers to column of table above.
Now I need to enter "Descr" value in first textbox column and as per the
corresponding "Part_ID", I need to populate the ComboBox with
"Part_Functions" in second column.
i.e. the Values populated in ComboBox should be correspond to the Part_ID
for that row only. The purpose behind this is that user enters a Description
of Part in first column, from which we can get "Part_MID". Now for second
column, the dropdown should be populated only with values that map to that
Part_MID in Table 2.
This is Windows Form DataGrid not Web Based Datagrid.
Please help me to solve this out.
Will appreciate a quick help,