Extract part qty with ilogic

[jletcher]

Ok I will try to make it as clear as mud what I would like to do.

Ok lets say I have an assembly with 20 parts.

I will make a detail drawing of the parts in the assembly.

In the detail part IDW I would like to have the qty needed for the assembly 1,2,4 ect.

So how I think the ilogic should work.

In the detail drawing have a rule named QTY when ran auto or manually Will pompt to pick the Top Level Assembly the parts are in.

The user will look for the top level assembly select it.

The rule would filter out all parts but the detail part number and return the QTY of parts needed for the assembly.

I only need the Qty.

I know this is done by the number of Occurrences in the assembly this I can find but what I can't find is how the user would look up the assembly and set it to parts only.

Like the pic below when doing a parts list.

I don't need the select view because it is a part and it would return QTY of 1 but the assembly may have 5.

Is there a way to do this?

[GKPByDesign]

Genius! 

[rhasell]

Hi

The original author of the code, thanks mate.

I have added your name into my code. (Always try and credit the authors in my code)

[cadman777]

MJ,

You're it!

Many times you bailed me out, and I learned a lot in the process.

Cheers!

[Anonymous]

Your solution was indeed helpful. I tried to figure out different ways but that one was the best 

[dliteful]

Thank you so much for this!  Is there a way to ignore parts marked for reference?