I have a value list which is dynamic based on the value of a global variable, which i use to limit the list based on the type of entity.
I have solicitors, referrers and agencies, all in the same table which operates.
My value list works fine the first time you bring up the selection box and enter a 'type value' using the said script.
- Code: Select all
globals.value_list_filter='Solicitor'
globals.input_temp_int1=0
databaseManager.saveData()
application.showFormInDialog(forms.dialogue_choose_solicitor,-1,-1,-1,-1,'Choose Solicitor',false,true,'choose',true);
This correctly brings up the list of only solicitors from the providers table as the value list is based on a limit using the field globals.value_list_filter.
When i fire up the same dialogue from another button on the same form, changing the value of globals.value_list_filter to 'Referrer', then the value list stubbornly stays in its initial form.
- Code: Select all
globals.value_list_filter='Referrer'
globals.input_temp_int1=0
databaseManager.saveData()
application.showFormInDialog(forms.dialogue_choose_solicitor,-1,-1,-1,-1,'Choose Referrer',false,true,'choose',true);
I am assuming that the first list is kept in memory and the change of global variable is not recalculating the list.
Is there something i can do to force this to happen?
Using 3.5.10
David