HI,
I want to consolidate references to a series of 1-N child records to a parent record by adding a list of associated part numbers (methods) to a base part number.
BACKGROUND:
I have a build of material. The lines consist of part numbers. Some part numbers may have 1-N "method" associated with them -- like how to do something. I have identified the relationships in the RLTNSHP and CODE fields. 1 = the Base P/N. 2 = 0-N Method P/N lines associated with a given Base P/N. I have filled out all P/Ns that do not have a relationship. The Method for a Base P/N is blank.
START POINT
TIER | BASE | PN | MTHEOD | NAME | REV | RLTNSHP | CODE |
1.1.4.1.11.4 | 12600125 | 12600125-015 | | WASHER,FLAT | C.7 | | 1 |
1.1.4.1.11.4.1 | 12600041 | 12600041METHOD4 | 12600041METHOD4 | PLATING AND COATING REQUIREMENTS | C.2 | 12600125-015 | 2 |
1.1.4.1.11.6 | 12602929 | 12602929-001 | | SUPPORT LEG,\ | -0.4 | | 1 |
1.1.4.1.11.6.1 | 12593834 | 12593834METHOD2 | 12593834METHOD2 | TREATMENT AND FINISH REQUIREMENTS | E.4 | 12602929-001 | 2 |
1.1.4.1.11.6.2 | 12593834 | 12593834METHOD8 | 12593834METHOD8 | TREATMENT AND FINISH REQUIREMENTS | E.3 | 12602929-001 | 2 |
GOAL/QUESTION:
I want to get rid of the METHOD P/N lines. But, I need to add the 1-N METHOD P/Ns to the Base P/N
DESIRED OUTCOME
| TIER | BAE | P/N | METHOD(S) | PART NAME | REV | RLTNSHP | CODE |
1.1.4.1.11.4 | 12600125 | 12600125-015 | 12600041METHOD4 | WASHER,FLAT | C.7 | | 1 |
1.1.4.1.11.6 | 12602929 | 12602929-001 | 12593834METHOD2,12593834METHOD8 | SUPPORT LEG,\ | -0.4 | | 1 |
