3 ms·
You could create a new table that keeps track of the logistics of the product. If the product is sent to supplier, a new row appears in this table with the date
by pprotas 4y ago
You could create a new table that keeps track of the logistics of the product. If the product is sent to supplier, a new row appears in this table with the date. If it hasn't been sent yet, no row is present.
- therein 4y agoHandles the cases where an order had to be resent to the supplier better as well.
- formercoder 4y agoAnd when a supplier returns a shipment, and when new things happen that you haven’t thought of so a new column isn’t needed.