Dear All,

The context

- I have 2 forms (VOWD, and Project) the relationship is 1 to many (1 Project, Many VOWDs)

- I have created a Pivot Table based on the Project form

- Using this Pivot Table (Project) I want to access the data from the VOWD forms

- To do so i have created a bi-directional look-up field (Multiselect) in the Projects form

the result is that I amnot able to view the VOWD form entrys in the pivot table!

If i change the lookup field to "dropdown" instead of "multiselect" then it works (i.e., i can see the VOWD in the pivot table). However, this will not work properly becuase the relationship as indicated earlier is 1 to many (1 Project, Many VOWDs).

Can you please tell me what is it that i am missing.

Thanks in advance.