Problem Solved
The issue was with the sql file I created I neglected to make sure that the DetailOrderID field in the orderdetails table matched the ID in the orders table.
Apologies for the confusion.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.