Multiple Combo Boxes in a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Richard

Try creating a form that has those combo boxes on it. Then create a query
that refers to the values in the combo boxes to get its criteria/parameters.
 
Back
Top