INTERESTING QUESTION! i have not done this but i'd approach this using a series of query programs. something like extract all parents and components out of the MBM file, then count each parent / component relationship to see how many times that relationship occurs, append this into each record, and then go back and check all components for each parent to see how many times it occurs with other parents. from this you should be able to determine if a the same set of components exists for another parent. again i have not done this, but this would be a real interesting series of queries to develop on a quiet Saturday morning. >>> daniel.warthold@xxxxxxxxx 12/08/04 12:28PM >>> Hi everyone, Is there an easy way, to check if there are duplicate BOM's, meaning the exact same components, quantities, no more no less, in the same facility, same method, but with 2 (or more) different parents? Does mot matter if the MBM.BSEQ, MBM.BBUBB, the effectivity dates, or any other fields, including the BOM notes (MPN) and ref des (MBZ) are different. Basically I'm trying to look for 2 or more manufactured items that are identical in regards to the list of their components, but have different item number. Like if the engineers designed again an already existing item, but given it a different item number? Thanks Daniel Warthold P. ENG CPIM _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: cdoe@xxxxxxxxxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.