[BUFFY]

Thanks for the replies...

So what your saying is... For SQL

Display products from the products table....

When a customer clicks the order button, insert productid, size and quantity into ordered_items table.
Retrieve orderitemID from the previously entered record, enter this (orderitemID) and the date, comments etc into the customer_order table.

Is that what you meant?


*Ive just realised my layout doesn't allow a customer to order 1 large and 2 meduims, just 3 of the same size. I think javascript will be able to change the amount of size boxes on the fly once quantity has been entered.