AnsweredAssumed Answered

If function

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

Title

If function

Post


     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

     SKU#

     Item Name

     Manufacturer

     Price

     Qty

     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

      

Outcomes