Hi, I’m making an inventory App that uses one table as a record for what items moved from and to what locations. However I’m trying to make an automated system that detects if someone creates a movement that makes the quantities at that location negative (moved more than were there). Once it detects that, it deletes that movement record and tells the user why it was an error and to make another one. Basically, I want a workflow that whenever a row is added to one table, to look at the values in another table and if they become less than zero, to delete that row and tell the user an error message. Any advice?
LinkedIn
Twitter
