I need help. I've been trying to figure out how to save the list of products being ordered within the database. The reason I am getting stuck is I'm not sure how to create a field named "productsOrdered" that retains all the "new" information for each product such as the new price and quantity to be added to the inventory.
I know for every Product being ordered there needs to be a minimum of 1 product ID that gets stored. The other data (to add further functionality to the system) that needs to get saved is a price and quantity.
If it was just a list of product ID's i'd be able to come up with some work around, but It's really a table full of data for every single order.
david8640
commented
10 years ago
@david8640 @omarhijazi22
I need help. I've been trying to figure out how to save the list of products being ordered within the database. The reason I am getting stuck is I'm not sure how to create a field named "productsOrdered" that retains all the "new" information for each product such as the new price and quantity to be added to the inventory.
I know for every Product being ordered there needs to be a minimum of 1 product ID that gets stored. The other data (to add further functionality to the system) that needs to get saved is a price and quantity.
If it was just a list of product ID's i'd be able to come up with some work around, but It's really a table full of data for every single order.