In an order system, there are tables of customers, products, orders, and order details, with the main fields listed as follows:
tblCostomer: CustomerID, CustomerName, ...
tblProduct: ProductID, ProductName, ...
tblOrder: OrderID, CustomerID, OrderDate, ...
tblOrderDetail: OrderID, ProductID, UnitPrice, Amount, Total, ...
I have created a query "qryTotalByOrder" which will sum up the total for each order by grouping corresponding products in that order:
qryTotalByOrder: CustomerID, OrderID, OrderDate, Total
I would like to add an unbound text box in a form " which will display the Total of a particular order by entering the orderID as a parameter. What do I need to put in the Source of Data of the textbox? Thanks.