dwindling value list slow to update

[Aussie John]

I have a dwindling value list I created ( see attachment) which appears to work but if I make some changes the value list does update straight away (as least on fields where a change has be made). I guess it is an indexing thing. Any ideas around this? thanks the test file is pretty straight forward. cheers

dwindling VL test.fp7.zip

[Aussie John]

Hope I have answered my own Q - run script to refresh (and flush cached join results)

I have attached the working version for info.

dwindling VL example.fp7.zip