Modification in Order
I created a sample complete store to order products.
So for admin he can view orders & edit status or so on.
The tables of order & orderdetails are same as what webassist provides.
So now if admin wants to modify the order by adding more products into the same order & change quantity & etc then how can we structure this?
Generally all orders will be modified.
So do i need to create another table or work with same orders & orderdetails tables.
How can this be achieved?