So, there is something that I am missing, and I feel like I am right on the cusp of getting this right, but at the risk of my sanity I figure it is time to call in the big guns.
I have a list form, I will call this NewEntry. This list form has a dropdown which is populated and filtered by another list, I will call this other list DataSource. On that DataSource list I have (or want to have) a single textbox, which I can enter a string of values (ie: Red;Blue;Green;Purple, etc...). On my NewEntry form when I choose an item from the dropdown (populated by DataSource), I would like the form to pull the string of values from the textbox string on DataSource and make them into the available choices on the MSLB.
What formula/rule do I need, and what is the necessary syntax?
Thank you in advance for review.