Thanks for getting back to me, I think you may not of understood my question properly.
This is for the admin pages not for a user. I managed to get it working by ammending the recordest on the orders_Detail page as below
SELECT OrderID, OrderAmount, OrderShipName, OrderShipAddress, OrderShipAddress2, OrderCity, OrderState, OrderZip, OrderCountry, OrderPhone, OrderFax, OrderShipping, OrderTax, OrderEmail, OrderDate, OrderShipped, OrderTrackingNumber, OrderStatus, orderdetails.DetailID, orderdetails.DetailOrderID, orderdetails.DetailProductID, orderdetails.DetailName, orderdetails.DetailPrice, orderdetails.DetailSKU, orderdetails.DetailQuantity
FROM orders INNER JOIN orderdetails ON orders.OrderID = orderdetails.DetailOrderID
WHERE OrderID = ParamOrderID OR ( -1= ParamOrderID2 AND OrderID= ParamSessionOrderID)
I kept the default paramaters and display the products ordered in a repeating table below the shipping address.