Pivot table - problem with page field for more tables

[John Elink]

Hello

I have 2 pivot tables. They deal with the same resource. Is there some
way, that when I change the field which is defined as "page field" in
the first table (i.e. Partner), that the same field (Partner, also
defined as "page filed") in the second table will change in the same
way? I mean, if I select in the first table "Company A", the second
table will also switch into "Company A" datas.

For exmaple

Table1
Company |Month
---------------------
Type |Quantity
Option1 |

Table2
Company |Month
---------------------
Type |Quantity
Option2 |


Thanks a lot

Cheers

Johny

 

[Debra Dalgleish]

The following thread has some code by Robert Rosenberg that will change
the second table when the first one is changed:

http://groups.google.com/groups?&threadm=eB5RRiIX$GA.255@cppssbbsa04