PXSelector with composite Substitute Key

I have SegmentID as identity column along with SegmentCD and Revision defiend with IsKey=True.

Now on Area page We have grid linked with AreaSegment DAC where user can select the Segment - for this we need to show SegmentCD-Revision in the column instead of SegmentID To achieve this we have created DisplaySegmentKey on Segment DAC that returns value SegementCd-Revision and on AreaSegment DAC we Designed SegmentID with PXSelector with search and DescriptionField - DisplaySegmentKey Everything works OK.

But on Import export where we use the value system does not convert it to SegmentID and gives null value error for Segment field.

We also tried by making DisplaySegmentKey as DB field and setting its value on Field Updated of RevisionID on Segment Graph and instead of Description field used it as substitute key but still facing the same issue

from Recent Questions - Stack Overflow https://ift.tt/3ssCHDL
https://ift.tt/eA8V8J