Pivot table based on multiple forms.

Pivot table based on multiple forms.

Hi,

I want to create pivot table based on multiple forms. I have three tables as describe below.

1. Trainer: This contains details of all trainers e.g. trainer name and age.

2. Trainer's target: This contains planned work for trainer. So each trainer will have multiple entries month wise. e.g. Trainer1 - Jan 2014 - 5 trainings and so on. This form has lookup field for trainer from  Trainer form.

3. Students: This contains student details, trainer name and training date. (Student data gets entered only after training).  This form has lookup field for trainer from  Trainer form.

I want to create a pivot based on  Students and  Trainer's target (Actual Vs Planned) . However while creating pivot it allows only on  one form and in column properties it shows only parent lookup.

Can anyone suggest if this is possible. Thanks for your help.


Regards,

Chaitan.