If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Looking up mulitiples items
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 |
#2
|
|||
|
|||
Looking up mulitiples items
On Mon, 27 Oct 2008 12:35:43 -0700 (PDT), Simon wrote:
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? -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|