Retrieving Lookup Value

[Former Member]

Hi

I have a scenario here.

Lets say, I have a Lookup Flat Table A which contains a field say Description. This field is a display field for 2 other lookup flat tables, say Table B and Table C.

When I am retrieveing all the records from Table A, for each record, I get a value from Lookup Table B and Lookup Table C. But instead of the text description, I get the Record IDs for Table B and Table C values in the record of Table A.

Is there a way, I can retrieve the text values for Lookup B and Lookup C, along with their record IDs, in the record of Lookup A ?

Thanks and Regards,

Sayan Ghosh

[Former Member · Accepted solution]

Hi Sayan,

If you have the Record object for Table A then you can use the method record.getLookupDisplayValue() to get the values for Lookup Table B/C.

Else to get the record/values for Table B and C, you can use the RetrieveRecordByIdCommand class and the RecordId retrieved for table B/C.

Hope this helps you.