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.