Lookup values

  • Thread starter Thread starter axapta
  • Start date Start date
A

axapta

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
 
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
 
Back
Top