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