I have three SharePoint lists based on the below examples:-
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 Andy