DataTables and DataGrids

[TheLizardKing]

Hello.

I am having a problem displaying the vendorName of a car type in my datagrid. The vendor information is in its own table, tblVendor, while the car type information is in tblCarType. Each car type has information on its name and stuff, and in the vendorID column it has a number referring to tblVendor. What I want to do is display information from both tables in my datagrid - the vendorName from tblVendor and the carType from tblCarType. The problem is I can't seem to find a way to populate the datagrid using tblCarType as my datasource and exchange the vendorID column with vendorName from tblVendor.

I'm sure there is a very easy and logical solution to this annoying and presumably easy question, but I haven't found it yet.

Anyone have an idea? :-)