I have 2 listboxes from 2 unassociated tables, and they contain the same 3 values, E, M, V. However, sometimes some of the 3 values will be missing from 1 listbox but not the other (because it doesn't exist in the listbox's table), like below:
Type1
E
M
V
Type2
E
M
How can I make a combined listbox that will have all the 3 values, and when a value is selected, it triggers select in field for both listboxes (irrespective of whether a value is missing from one of the listboxes)?
Hi Ashfaq, I did yes, but the key thing missing was the concatenate in the script between 2 resident loads. This helped to create a listbox with all values, after which select in field triggers can be applied:
