R
Richard Horne
Hi guys, please help.
I have two tables, Orders and OrderDetails
I want to be able to query an Order and its Details based on 2/3 combo
boxes, for example:
I want to be able to first select the Customer from a list of all customer
who have placed orders, then I want the next combo box to show a list of all
Item_Types that the customer selected in the first box has ordered. I want
that Order and its OrderDetails to be displayed below the form. How do I do
this?
The important field names are as follows:
Orders
--------
OrderID
Customer
OrderDate
OrdersDetails
I have two tables, Orders and OrderDetails
I want to be able to query an Order and its Details based on 2/3 combo
boxes, for example:
I want to be able to first select the Customer from a list of all customer
who have placed orders, then I want the next combo box to show a list of all
Item_Types that the customer selected in the first box has ordered. I want
that Order and its OrderDetails to be displayed below the form. How do I do
this?
The important field names are as follows:
Orders
--------
OrderID
Customer
OrderDate
OrdersDetails