Either lookup the other table by the id returned in the first table, or
return the values to your form from a view or stored procedure which can use
joins to return the lookup value from the other table.
Kind regards,
Rob
"axapta" <ja********@gmail.comwrote in message
news:3F**********************************@microsof t.com...
I'm returning values in my form from a table. However some of these
values are based on lookups stored in another table. How can I retrieve
the description of the values from the lookup table based on the code.
Regards