AnsweredAssumed Answered

If function

Question asked by MehrdadBastan on Mar 15, 2013
Latest reply on Mar 15, 2013 by philmodjunk


If function


     Hi Everyone,

     I have a created a very simple inventory database and would like to get your help.

     Here are the fields in my database


     Item Name




     Extended Price

     I would like to Scan a bar code and if the SKU# is not in the database already the script to open a DATA ENTRY LAYOUT and allow me to enter the info. However if the SKU# already exist I need the script to just add one more to the quantity. No need of creating a new record in that case.

     what is the simplest way to write this script?

     Thanks for your help