update 2, I set fields such as OrderUserID & OrderFax in the thought to be unused Orders table but then got the following message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KG,'Ammonium Nitrate',118.2,1)' at line 1
The line item in order summary shows as:
Item Price Quantity Total
A1110-2.5KG Ammonium Nitrate 6484-52-2 $118.20 1 $118.20