Datagrid and dropdown column

[smitty]

I've got a datagrid with a ADODC control. I nee one of the columns to have a drop down and be populated by another table. I can do this in access, when I create a form using form view and changing the control source.