Data Grid Control

[Mitch W]

Hello,

I am having difficulties with the DataGrid control. I have a table Table A
with fields (userid,name,buildingid...). Table B has fields (buildingid,
buildingname...). Table A & B are linked by buildingid. I would like the data
displayed in a DataGrid. If I setup a dataset off of Table A - when the data
displays it displays the buildingid. What I would really like it to display
is the building name, but with a list of other buildings from Table B as a
selection tool. I guess a combo box within the DataGrid.

Any suggestions on how this can be done would be greatly appreciated.

--mitch