How to prevent my "inventory on hand" from getting a negative quantity?
I think I'm almost done with my inventory data base. Thanks a lot in all the help you provide here (@GuyStevens). I have all my calculations down pat and my conditional values working. Now, I would like to get a custom dialog if the person in charge of data entry oversells an item. For example, if I have 5 cases on hand, I only want said person to be able to sell no more than 5. in other words, I dont want any negative quantities in my stock. I know I need a script or a trigger here, but I'm not sure how to go about. Any help would be greatly appreciated!