Database Script Help
Im trying to make a databse that has one small purpose. To count UPC Codes. This is for my store inventory. Im using Filemaker Pro 11, and a Bad Code Scanner on my Notebook.
What I want is to be able to just scan the bar code and move on and at the end, it has a count of every quantity of Barcodes I have scanned. So I can export them to Excel and import them Back into my POS System. But I cant get it to do that. So Logically it would need to see if the barcode exists, if it does it counts +1, and if it doesnt then it needs to create a record, and count +1. I cant seem to get it to work.