Page Definition SQL Syntax - Filter Table Based On Page Name

[JasonTaylor]

I'm sorry if this is more straight forward than I'm making it out to be. I want filter Data Sources in Graphic Table Elements based on page name, much like the way a Page Definition using Data Driven Pages selects data from a feature class based on page name. On the Page Definition Query help the following is mentioned:

A Page Definition Queries is a dynamic SQL Where clause based on the values of the designated page name field for Data Driven Pages. Therefore, layers being defined must contain an attribute and appropriate values that can be matched to the designated page name field of the Data Driven Pages index layer. Page Definition Queries react to any change in attribute values in either the index layer field driving the Data Driven Page name or the field specified in the Page Definition Query dialog box. You may need to refresh Data Driven Pages to see any changes for the page currently being viewed.

So, I'm assuming that there is an SQL Query that I can set in an Attribute Filter in a Graphic Table that does the same thing. In a desperate attempt I tried to set my page attribute to equal the dynamic text code for page name but that didn't work, as expected.

Again, I apologize in advance if this is in the help somewhere. I can't seem to find it though.

Thanks!

[JasonTaylor]

Something I've noticed: When I go to enter a an attribute query, with Page Definitions turn on for the layer used as the table's data source, Unique Values for the that field show only the value used for the current page, not all the values on the table. I thought that using a wild card expression - "PAGE_FIELD" LIKE '%' - would yield all values found in  the Unique values window, but it uses all the values on the table, not just the ones that seemed to be query by the Page Definition.

[JasonTaylor]

SOLVED: Argh, Checking "Honor Definition Query"  in the Data Filters dialog honors the Page Definition Query, limiting my results to what is being displayed on the page. I guess I just have to talk these things out sometimes.