Picklist preserves previous choices
Hi tech support
We have an application (for church service and roster) which contains multiple dropdown picklists. These picklists' choice is empty and dynamically generate items according to choices from other picklists. It all worked fine until recently.
What I discovered is every time dynamic picklists generated, selected and submits, the chosen item actually inserted to the picklist statically. After 30 odd times, the dropdown picklist has 30 entries.
On the form, using 'clear picklist', I can still generates properly itemlists correctly without displaying statically saved dropdown items, but when hit submit button, an error message pops up.
After deleting all saved (apx 30-40) entries from 'dropdown'->'Edit this field'->'the choices', it started working properly again. Somehow the problem is caused by 'accumulating selected items' in dropdown list.
'Clear' does clear items in dropdown on the from (in eye) but does not really remove items from the dropdown. It becomes an issue when too many items get saved statically.
Is there any way to 'stop accumulating items from selection'? or 'remove all pre-defined items of picklist on load'?
Thank you in advance