I’m trying to create my first app with a client for purchasing. I’m struggling with the logic.
I have the following Tables:
- Order Items
When a user clicks the product, they can add to basket (Adds an Order Item), they can keep adding to basket and will create Order Items.
When they go to the basket they will see a list of these order items and can purchase using stripe. This will create an Order.
This bit I can do but I want to then update all the current Order Items for that user with the Order number (From the Orders Table). I can’t seem to do this. am I doing something wrong? is the design wrong?