I've made a valuelist based on a year field in one table and restricted its values by a second TO based on a global field that contains an ID. What this does is gives a limited year valuelist depending on what ID I want to display. And this all works well. But what I was also hoping for was when I clear the global ID field, I wanted the year valuelist to display all the years from all the records. To that end, I use a script to create a list of all the ID's and place them in that global ID field, but it doesn't return any records when I do that. I'm quite certain that this works when using as a portal, so I'm surprised it's not working as a valuelist. Does anyone have any thoughts for something like this?
I figured it out! It turns out it was working as expected. When I create a multi-lined key field I needed to do a simple window refresh and the valuelist then changes properly.