Add details from items table on order history page.
Before i put the site (which is very nearly complete) online i need to accomplish a couple of things. I'll begin with my first dilemma which is to do with the order history page. Basically i need to make some of the details from the items table available for the customer to view on there history page (only the items they've ordered that is)
I created the history and detail page using the DAssist wizard as described in the tutorial. I'm now thinking the best way to achieve the desired result is to make the orderID link to an items page rather than the details page. I've done this, i've created the items page with DAssist and changed the link. At the moment when you click on the link all items from the items table appear but obviously i need only the items ordered by the user to appear. I've tried altering the SQL statement and variables on the 2 pages to get this to work but i'm hopeless with complex statements so i could do with some help. Can you tell me the correct statements/variables needed.
It maybe the case that all 3 pages are required for this an to work, an order history page, details page and an items page. If this is the case thats fine as long as the items info from the items table can be viewed somewhere, thats the main thing. pls advise me. Thanks