I tried multiple things before writting, but i'm stuck on removing some duplicates on my form.
As you can see, i have 3 lookup columns that are getting there informations from multiple lists. Those column are meant to get the value of one another when i select them as im going down on the form..
but it gets me multiple value in my lists which could be confusing if we have to add some items.
Also, does someone have solution to get items from one lists instead of multiple.
What duplicates are you seeing in the output?
Is it coming from the Course or Date list?
One way around having multiple lists,
I have not done this with 3 tiered cascading lists, but I know it will remove the duplicates from a 2 tiered list.
If you can apply a view to your source master list, you may be able to achieve a 3 tiered cascade easier. I have had success using this method, but I think I had to use the Group By function in creating my custom view in order to pull back 1 value of each.