ok right.. thanks
am half way there but am stuck with the WHERE statement.
In the tut, it says change the WHERE to
WHERE orderdetails.DetailOrderID = WADAOrderID AND orders.OrderUserID = paramUserID
but I dont have a WADAOrderID column or reference to it in what I am doing and not sure what I should replace that with.
Leading on from that, am not sure what the added variable should be but I guess that would become clearer when I know what the WHERE statement should read as.
Currently, my tables structures are in the image attached.