You could make an access database by assembly and have the person enter the
designator. The databse could contain the approved vendors, part number,
designators, notes, etc. Then a query could be made to look up the
designator and go to the record or you could make a customized report. If
the BOM is sent or can be put into the proper format the data could be imported
an minimize the data entry task.
Kathy