Skip to Content
0
Former Member
May 18, 2010 at 04:01 AM

Retrieving Lookup Value

54 Views

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