Db triggers action

by a.sancti   Last Updated July 12, 2019 18:06 PM

I am trying to make a simple inventory system with automatic reordering. In the inventories db I have a list of items in the inventory and I have a critical value entry for each item, a value that when reached should prompt a reorder from the warehouse without any user involvement (for example in the inventory if we have 50 phones and the critical entry for the phones is 10 it means that when the phones available get to 10 or less than 10 the system should prompt the warehouse for an order of phones to add up to those remaining). How can I use triggers to populate the reorders table when the critical quantity is reached?

Related Questions

Trigger to log Users Assigned to website

Updated January 22, 2019 16:06 PM

How to use a trigger to only insert one row

Updated March 26, 2015 14:02 PM