Hi All,
I am relativeley new to Infopath and Sharepoint. I have been asked to create a form which itself is relatively straight forward....but I am trying to create a cascaded drop down list and failing!.
I have searched the web and this sites but I seem to be doing something wrong. I want a drop down list called site to only show project managers that manage that site.
I have created two lists on sharepoint, one called sites the second list called project managers which has an additional column that looks up the sites on the site list.
The form can see the lists and the correct data can be chosen.....no problem there. When I try to filter the data so when a site is chosen it populates with the relevant project managers....I get either a blank list or list of ID numbers.
I have tried numerous variations but no success. I assume I have doing something basically wrong but unable to correct it. Any suggestions would be appreciated.
Thanks.