Looking up mulitiples items

[Simon]

I have a button on my Shop Database, i have writen the code so i can
email the customer confimirming thier order.

The only bit i can not do is display the products the customer has
ordered

the products the customer has ordered are stored in tblOrderProducts
along with the Order Number

with in the email to customer i want to list the products the customer
has ordered along with quanity


How would i go about looking up details and displaying if there are
many recoreds

Thansk

 

[John W. Vinson]

I have a button on my Shop Database, i have writen the code so i can
email the customer confimirming thier order.

The only bit i can not do is display the products the customer has
ordered

the products the customer has ordered are stored in tblOrderProducts
along with the Order Number

with in the email to customer i want to list the products the customer
has ordered along with quanity


How would i go about looking up details and displaying if there are
many recoreds

Thansk

With a Query joining tblOrderProducts to the Products table. You could base a
Report on a Query joining tblOrders to tblOrderProducts to tblProducts, to get
fields from all three tables.

What is stored in tblOrderProducts (it should be a ProductNo, a link to the
primary key of the Products table)?
Where are the details for the product stored?