Linking Custom Properties from Assemblies to Drawings

Hello,

I am currently working on setting up way for my companies title blocks to automatically populate certain information from 3D.  Essentially the way I have it setup is that the custom properties are filled out in each individual component and then when inserted into a new drawing that information is transferred using formulas in the drawing custom title block such as \$PRPSHEET:"Part Number".  This works great when making part drawings as people can make as many drawings as they need for mfg or for customers using the same components and title blocks are filled out with the pertinent data.  The issue I am having now is I want this same system to work for assembly drawings.  Now for some of the properties I can use this same system and it works just fine.

The problem is that our title block is setup to list out all sub-components instead of using a BOM.  So I want to be able to setup the drawing to be able to reference the assembly so I could have \$PRPSHEET:"Part Number 1", \$PRPSHEET:"Part Number 2"  and so on and they would correspond directly to the assembly.  This would work well but it would mean that people would have to fill in the assembly properties directly.  What I am wanting is to be able to use the part custom properties to fill in the assembly custom properties in the order that the components are inserted into the assembly.  So that custom Property of the first component would populate Part Number 1 while 2nd inserted component would populate Part Number 2. What I am wondering is if anyone has been able to do this and what syntax I would have to do to make this work.

As a secondary question if I use multiple of the same component is there a way to make it so that it only inserts the data for the part once?  Does inserting vs patterning/mirroring make a difference?

Any help would be greatly appreciated.

Thank you,

SolidworksDrawings And Detailing