I have a created a very simple inventory database and would like to get your help.
Here are the fields in my database
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