Soldato
Maybe a long shot asking here but need to help with InfoPath and SharePoint.
I have three SharePoint lists:-
ListCountry
CountryName : Single Line of Text
ListCity
CityName : Single Line of Text
RelatedCountry : Lookup [ListCountry:CoutnryName]
ListBuilding
BuildingName : Single Line of Text
RelatedCountry : Lookup [ListCountry:CountryName]
RelatedCity : Lookup [ListCity:CityName]
Now I want to setup an InfoPath form for the ListBuilding list so when I add a new entry I first select the country, then city, and then populate the building info.
The form can access both of these lists fine via drop downs however I’m struggling to setup a filter so that once I select the country only the City’s within that country are visible from RelatedCity lookup.
I know this is possible via InfoPath but can’t get it working, any pointers/ideas?
Many thanks
I have three SharePoint lists:-
ListCountry
CountryName : Single Line of Text
ListCity
CityName : Single Line of Text
RelatedCountry : Lookup [ListCountry:CoutnryName]
ListBuilding
BuildingName : Single Line of Text
RelatedCountry : Lookup [ListCountry:CountryName]
RelatedCity : Lookup [ListCity:CityName]
Now I want to setup an InfoPath form for the ListBuilding list so when I add a new entry I first select the country, then city, and then populate the building info.
The form can access both of these lists fine via drop downs however I’m struggling to setup a filter so that once I select the country only the City’s within that country are visible from RelatedCity lookup.
I know this is possible via InfoPath but can’t get it working, any pointers/ideas?
Many thanks