I have an Access DB that will be used to integrate third party BOMs of electrical hardware. This third party used their own part db to build their BOMS. I have integrated their part db into our MRP db.
In the Access db, initially their parts will be matched directly to out parts with exact matches on Manufacturer's Part Number. Next, their parts will be matched to our parts based on the specifications of the specific commodity code per part. This match will list one part from their BOM and all the specification matches from our MRP db, including their previously integrated list of parts. The idea being that we will try to match their part to one or more of our existing (stocked) parts. If we have possible matches the third party will choose one. If the third party doesn't like any of our possible matches we would then purchase the part and list it as a direct MPN match. Parts that have no MPN or specification match are purchased and then become direct MPN matches.
So far I have reports that list the three possible states of any given part; direct MPN match, possible specification match, and unmatched parts based on MPN and specifications. The direct matches will be able to be added straight to my BOM. Once parts are procured for the non matched parts they will added to the BOM too. What I need now is a way to take the list of possible specification matches and click a button or check a box next to one of my parts that they have chosen and have it placed into my BOM. Should I use a form or report? I have a report that lists nicely their part and my parts but how do I set up the choice mechanism?
Once the BOM is complete in the Access routine a .xml file will be exported and that list will build the actual BOM in my MRP system.