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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top