KPNeedsHelp
Technical User
I'm hoping someone out there has tried to do this and can offer some help
I've created a BAQ that pulls level 2 of my BOM, however I'm having trouble with items that have multiple approved revisions.
My parent part table is PartMtl and I have linked it to PartMtl and given that table and alias of Level2. The table relationship is PartMtl Parent MtlPartNum to Child table Level2 PartNum. I can't link on the revision number because then it only pulls the BOM parts for 8888 Rev A and I need it to only pull BOM parts for 8888 Rev D.
Example: My parent part in level 1 is 9999 Rev A
in my BOM I have a subassembly part 8888 Rev D. However, part 8888 also has approved revisions A, B and C.
I can't get my BAQ to only pull the revision that is in the actual BOM, it pulls all revisions.
Is there even a way to do this?
I've created a BAQ that pulls level 2 of my BOM, however I'm having trouble with items that have multiple approved revisions.
My parent part table is PartMtl and I have linked it to PartMtl and given that table and alias of Level2. The table relationship is PartMtl Parent MtlPartNum to Child table Level2 PartNum. I can't link on the revision number because then it only pulls the BOM parts for 8888 Rev A and I need it to only pull BOM parts for 8888 Rev D.
Example: My parent part in level 1 is 9999 Rev A
in my BOM I have a subassembly part 8888 Rev D. However, part 8888 also has approved revisions A, B and C.
I can't get my BAQ to only pull the revision that is in the actual BOM, it pulls all revisions.
Is there even a way to do this?
