Maybe there is another way to achieve this, but my issue is:

depending on value of column(1), I need to populate the dropdown of column(2) to reflect it.  I can do that just fine, the problem occurs when the the selected value of column(2) is no longer in the dropdown after being repopulated for a different row.  The text of the cell shows the value that was selected, and loses the display text.

So after searching for a solution, it appears making column(2) a template column with 2 dropdowns in it, 1 filled with all possible values, and the 2nd only have the values relevant to that row.  When the cell is being edited, show dropdown 2, else it should be dropdown 1 so that all values can display properly.

How do I access the dropdowns from the template column, both client side and server side?

Any other simpler solutions?