Product Number MisMatch
I have created an inventory database for my forms and clothing wear. I have set up a part ID and Product ID fields that have the same entry for each specific product listed in each field. I have a bluetooth scanner that I would like to scan the barcode and have it enter the product ID in the system. I have it set-up and it is working for 90% of the barcodes. My issues is when I scan the barcode it appears correct in the Part ID but shows a totally different Product ID, so the description, price, etc is not correct. Any suggestions.