History Pages - didn't quite work!
Thanks for this. This statement worked so far as allowing me to insert items from the items table (ie. ItemThumb1) onto the history details page however, if i look at order 26, for an order of 3 different items it lists the same itemthumb 3 times as opposed to listing the three items that were actually ordered (which should all be different), maybe some sort of parameter or variable is needed so that it lists only the itemthumbs for that particular order. Is that right or should it work without any extra bits.
In addition to the above, i'm hoping to use data assist to create a searchpage for seaching the orderID from the orders table and a results page with images and details from the items table. so if i search order 26 it would bring up 3 different images and the relevant details from the items table would appear below the image.
I've already tried this but had the same problem as above. At the beginning of the wizard i chose the orderdetails table, i deleted all items to search on except orderID. When i tried out a search it showed the name and description correctly as these items are actually in the orderdetails table. But the details from the items table below each image were all the same, i figured the easiest way to get it to work properly would be to add new columns in the orderdetails table next to name and description but maybe it can be done by creating a join statement like the one you provided for the history details page?
I should probably try to get the history pages sorted first and if i can't, i guess i'll have to revert back to my original plan. pls advise.