Creating an invoice-one Customer ID-multiple Order ID but just want one to show

[charleyh]

I am creating a shop like database where i have a customer ID and order IDs for each different order. One customer can make multiple orders which are identified by the order ID however this produces a problem when creating my invoice as it always shows all the orders that customer has made rather than just one. Attached is an image of the information i have included to run the query.


How can i get my invoice to just show orders from one day or one specific order for that customer. Otherwise their 'receipt' will show all orders they have ever made with the company and so the total will be wrong.

[ranman256]

Make master/child forms. (Sub form)
The master form shows the client, the sub form shows the orders by date.
a button on the header can then open an individual order to show its details.
Docmd.openform "frmOrder1",,,"[orderID]=" & subForm.form.txtOrderID

another way, 3 list boxes on a form
list1 shows clients
list2 shows orders
list3 ,details of that order.

Each time you click lstClient, it filters the orders in lstOrder.
same w lstOrder. Click lstOrder, the AFTERUPDATE event would filter the contents of lstOrderDetails.