>Hi Everyone,
>
>I would like to display within a grid information pertaining to a specific item number.
>
>I have the following four tables.
>
>Sales Order, Sales Order Items, Customer File and the Item File
>
>I would like to display within the grid ALL sale order items from the Sales Order Items table, for a specific item, regardless of the sales order they belong to. It will represent the history of any given item number.
>
>With the above display, I would like for each sale order item line found, to display the CUSTCODE, customer who placed the order, which is in the parent Sales Order table, and the CUSTNAME which is stored in the Customer table, and the Item Name which is stored in the Item table.
>
>Can I do this with one SELECT-SQL statement?
>
>Thanks in advance!
Yes you could John.
This pretty much resembles testdata.dbc's, customer, orders, orditems and products table joining :) There is a sample view in testdata.dbc doing it. Open the view in designer and check SQL syntax.
Cetin