Drawing revision as custom property of Part?

All,

In my company we have found a need to populate a custom property of a part from a property of a drawing of the same file name in PDM.

specifically:  I want property "DWG REV" in part "A.sldprt" to represent property "Revision" from drawing "A.slddrw".

I'm thinking a macro that, for each part in PDM, finds a drawing of the same file name, grabs the rev property value, and inserts it into the part properties.

Is this feasible, and if so, can anyone help me out on this?

Many thanks,

-Jon

SolidworksApi macros