Hi There,
I have 2 tables are not not linked.I want to keep them as it is and doing selection on one field value will perform selection on other using onSelect trigger(in document properties).
OnSelect trigger-(SelectInField)
Field:Branch2
Value: =IF(GetSelectedCount(Branch1),'('&Replace(Concat(DISTINCT Branch1,'|'),' ','?') & ')','')
The issue i notice is, when user do multiple selections and try to clear the one of the selection, "the trigger doesn't remove the selection".
Say I selected on Field Country1, the trigger automatically select on Country2(if value is found). But when i do futher selection on Field Location1 and then deselect it, the trigger doesn't remove the selection on Location2.
eg- Select on Country1- UK, then select on Location1- London and deselect Location1- London, you will notice Location2- London is not deselected.
This issue is not there when it is single selection.
Please help.
