Hi guys, been trying to tackle this one, but no luck. I did get somewhere but my workaround did not work.
Basically I have 5 Dropdowns. They all contain the same list of Vendors. However as you select a vendor, I want the other dropdowns not to display that vendor anymore as a choice. I did some crazy stuff, with variables and collections but basically ended up with a final collection that has only the "not selected" vendors. I am updating this in realtime using a timer.
The problem I have is I am hitting a loop. If I set the dropdown Items property with that collection that only shows the available Vendors. As soon as I click the value, the dropdown resets itself. I am assuming it is because as soon as the value is selected, it tells that Collection I am no longer available, so it then is no longer part of that collection and is no longer a valid choice, and not an Item. I tried trigger this OnChange instead of timer, but no luck, and brain fried, so maybe I am overlooking something.
I am open to other approaches, etc. But basically I just need all 5 dropdowns to be unique. They cannot be the same value. Once a Vendor is selected it can only be selected once. I can make rules, to auto reset, the fields if I can't solve this, but ideally they wouldn't even see the value as a choice in their dropdown. Basically the dropdowns are dependent on each other.
Hopefully someone can help! I will have several thousands of vendors, so we have to be mindful of delegation.
Thanks!
