Multivalued Lookup field

[Former Member]

Hi,

Need some help on the Multivalued look up field in the main table.

There are 3 tables X, Y, Z (Main Table)

X is having a field A(PK).

Y is having B,A(Look up from X) (Combined PK)

Both the fields A and B are combined Unique keys.

Z is having a Multivalued Look up field from Y(A,B).

The sort order of this field in drop down is according to field B.

We need to change the sort order according to A.

Please can anybody suggest a way out.

Thanks in advance...

[Former Member]

We would like to change the same in MDM as MDM Data manger and Import Manager is used to update the data.

[Former Member]

I would suggest just check the display field sequence, if you have not on display field then make A field as 1st display field and then B as 2nd so sorting change base upon field A.

Kindly check and revert back.

Thanks,

Jignesh Patel

[Former Member]

Field A is First display field and B is second but still the sorting is done according to the field B.

[Former Member]

Hi,

If you are not exposing MDM via Data Manager to the end user but via Portal, then use Portal custom code to sort this while displaying.

Not sure, whether this can be done in MDM.

Thanks,

Shambhu.