Hi there.
I'm building a Query to print out an invoice.
I have these tables:
Customer Details
OrderForm
Product Details
ProductsPurchased
And these are the fields put in the query:
*From Customer Details*
CustomerNumber
Name
Address
City
Country
Postcode
Customer Discount
*From OrderForm*
Order Number (Criteria = [Forms]![Order Form]![Order Number])
Order Total
*From Product Details*
Product Number
Product Name
Unit Price
*From ProductsPurchased*
QTY Purchased
Problem is this:
It will display the query with the same stuff, twice, for example, if we ordered a Dining table, it will display that twice (or however many Qty's u ordered) along with the items we haven't even ordered!
How do I solve this problem so it only shows the details we have ordered.
The ProductNumber and CustomerNumber are a combo box in the orderform form
I'm building a Query to print out an invoice.
I have these tables:
Customer Details
OrderForm
Product Details
ProductsPurchased
And these are the fields put in the query:
*From Customer Details*
CustomerNumber
Name
Address
City
Country
Postcode
Customer Discount
*From OrderForm*
Order Number (Criteria = [Forms]![Order Form]![Order Number])
Order Total
*From Product Details*
Product Number
Product Name
Unit Price
*From ProductsPurchased*
QTY Purchased
Problem is this:
It will display the query with the same stuff, twice, for example, if we ordered a Dining table, it will display that twice (or however many Qty's u ordered) along with the items we haven't even ordered!
How do I solve this problem so it only shows the details we have ordered.
The ProductNumber and CustomerNumber are a combo box in the orderform form
had to create a link between the Order Number from the products purchased table to the ordernumber on the order form table (going from orderform table to productspurchased table)
