Verify Values to another Table

Discussion created by RishiKhanna on Oct 16, 2015
Latest reply on Oct 22, 2015 by Mike_Mitchell

I have an inventory manager that keeps track of product Id , location, and bin assignment. Basically the user should be able to change which Bin the product is in, without a drop down it needs to be a text field.


I am trying to fix an error where if the user adds a bin that is not existent in our Bins table which the bin assignment above points to, it shows a popup, or something of the sort that asks them are they sure they want to save, in which case it would add a new record to the bins table with that value and then save it, or it would allow them to cancel the save


Thanks for your help