DataGridView With Columns From Multiple Tables?

I have 3 related tables in a DataSet - Customers, Products and Orders.I am trying to create an "editable" DataGridView which, ideally, will contain columns from all the tables. I have tried creating the joins in the TableAdapter SQL, but this results in a read-only data grid.

Customers and Orders are joined in a 1:M relationship by CUSTID.

Products and Orders are joined in a 1:M relationship by PRDID.

When the user adds a new Order record they will key the ORDERID, CUSTID, PRDID and QTY.I would like the DataGridView to display the related CUSNAM and PRDDES as soon as the user has keyed the Order record.The data must be displayed on a single data grid row. I am not interested in drill down or multiple data grids.My data looks like this:

Orders: ORDERID, CUSTID, PRDID, QTY

Products: PRDID, PRDDES

Customers: CUSTID, CUSNAM

The data grid should look like this:

ORDERID, CUSTID, CUSDES, PRDID, PRDDES, QTY

My SQL would look like this:

SELECT Orders.ORDERID, Orders.CUSTID, Customers.CUSNAME, Orders.PRDID, Products.PRDDES, Orders.QTY

FROM (ORDERS

INNER JOIN CUSTOMERS ON Orders.CUSTID = Customers.CUSTID)

INNER JOIN PRODUCTS ON Orders.PRDID = Products.PRDID;