List Box sync

[Anonymous]

I have two list boxes, one lists our customer's names and one lists the customers code (A001 format) in our system. At present these are sorting in alphabetical order which is fine but reading in line between the two they do not sync. I wish to leave the customer code in alphabetical order but sync the names to them.

[Anonymous]

Thanks for the input. I have found a temporary solution utilising a Table Box which has synced as required and added a 'Customer Search'

[chetansehgal]

Try Using Dual on both the fields, but only if both are at the same granular level. After doing that sort both the fields Numerically on UI.

e.g.

temp:

LOAD * INLINE [

    F1, F2

    aa, g

    ab, d

    sd, a

    tr, b

    we, gg

    fd, zz

    c, kk

] ;

NoConcatenate

Sort:

load Dual(F1,Autonumber(F1)) as F1,Dual(F2,AutoNumber(F2)) as F2 Resident temp Order by F1 asc;

drop Table temp;