The actual usage is for a small repair shop. I believe I have the 2 tables set up correctly, it's the implementation of the form for my very non-tech savvy mechanic. I have about 100 inventory items that this shop uses - some for repairs, but others for shop supplies (think WD40 used to repair a...
Been a long time since I have Access coded. I have one table (named Inventory) that contains 100 inventory items for a small shop - 3 basic fields: Part Number, UPC, Description. I want to build a form that let's me either enter the part number or scan a bar code to search for one inventory item...