DataGrid lookup values for foreign key

[whooper]

I have a datagrid that needs to be updated with a lookup value from a foreign key. The grid should show the text (lookup) value, but store the ID value. I would like for the user to have a dropdown of possible values.

In VB6, this could be done with a nonvisible combo box and a stdDataFormat variable (along with the datagrid).

Any ideas on how this in done with .Net? All the books that I have just show basic 1 table queries.


Thanks in advance.