DataGridView with columns from multiple tables

[msgjunkie]

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.CUSNA ME, Orders.PRDID, Products.PRDDES , Orders.QTY
FROM (ORDERS
INNER JOIN CUSTOMERS ON Orders.CUSTID = Customers.CUSTI D)
INNER JOIN PRODUCTS ON Orders.PRDID = Products.PRDID;

Can someone please point me in the right direction? Any advice is much appreciated.

[msgjunkie]

With some guidance from DeborahK on MSDN Forums I have managed to configure a TableAdapter to Use SQL joins by following this tutorial: http://www.asp.net/learn/data-access...ial-69-vb.aspx

I had originally tried creating joins in the TableAdapter SQL, but this resulted in a TableAdapter which was not updatable (no insert, update, delete methods). The trick is to use Stored Procedures which is clearly detailed in the tutorial.