Showing all values from 2 unrelated listboxes

[sifatnabil]

Hi,

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)?

[ashfaq_haseeb]

Did you check my reply?

Regards

ASHFAQ

[sifatnabil]

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:

CombinedTable:

LOAD

Session as MMType,

'Session' as flag

Resident Table1;

concatenate

LOAD

Session2 as MMType,

'Session2' as flag

Resident Table2;