data driven pages and using sql / python queries based on them

Discussion created by veltre.sam on May 30, 2012
Latest reply on Jun 4, 2012 by jbarrette-esristaff

I am trying to use queries based on data driven pages and page definition queries already set. Here is the run down of what I have done / tried:

Created DDP and then on layers applied a PDQ.
Tried to join other layers to the PDQ layers to display only features per specific map.

The problem is I have features that do not have the page name present in their attributes and cannot use the PDQ because of this. These datasets are locked and thus I cannot add fields. I realize I cannot preform the PDQ on a field not containing the DDP names. And in the work around I attempted, I set the PDQ on a layer, join to it, but once joined it does not reflect the PDQ, rather any and all matching records.

Is there any code I can use to reference the specific DDP and then a different field rather then the one the page name is based upon? I am sorry if this is jumbled.

Thank you in advance for any help.