September 10, 200718 yr Hi - I have a drop down field that shows values from a value list, defined to show only the second field in its definition. Works fine except that each time a new value is added (on a different layout in related table), when I come back to the layout where the drop down field is, the new value is not there the first time. If you click on a blank area of layout, and then drop down list again, the new value is there. Sometimes, just dropping it down a second time shows it. Is there a reason it's not showing up the first time, and is there anything I can do in a script after adding a value so that this doesn't happen? Thanks, Michael
September 10, 200718 yr This is a refresh issue. First, make sure that the related record containing the new value is committed before leaving the record. Then, if possible, script the navigation between layouts to refresh the window and flush the cached join results on the layout where the drop down list is.
Create an account or sign in to comment