I have 3 custom lists and 1 custom form.
- Country , State
- State, City
On the custom form I'm having trouble connecting the lists correctly. I have three DDL fields on the custom form.
Country - New data source from Country list (Value: Title, Display: Title, no filter)
State - New data source from from State list (Value: Tile, Display: Title, filter where Country DS - Title equals State DS Country)
City - New data source from City list (Value: Title, Display: Title, filter where State DS - Title equals City DS State)
What am I doing wrong here? I get all three dd's with all the values. They are not cascading based on the prior choice.