The inventory table stores the sizes and their inventory for products with sizes, and it stores the inventory for products without sizes columns are:
inventoryid, prodid, size, quantity
I want to reference the inventoryid in the order_items table so that the store owner can see what size of an item a customer purchased. I will set up the page in the admin.
As you suggested, I will add an itemid into the order_items table. Currently, all of the info that I want in the order_items table seems to be posting. When I change the table, I will need to redo my pages. I am not sure how to get the inventoryid into the table for order_items. I have a record set on the page with a join joining the inventory.prodid to the products.prodid
Thank you