AnsweredAssumed Answered

How can I create a value list via eSQL with ID and name?

Question asked by disabled_Luna.media on Dec 20, 2014
Latest reply on Dec 20, 2014 by disabled_Luna.media

Hi there,

 

in another topic I aksed how I can get all active "accounts" into a vlaue list in another table/layout. Several apporches were discussed. One led to eSQL as this aproach do not need any TO.

 

This worked well as long as I just wanted to see and store the (active) accountnames. But what if I want to see the (active) accountnames, but store the ID of a selected account?

 

Value lists do have up to 2 fields (e.g. ID and accounrname) that can be selected. But is that also possible to do with a mutiple-value global field that s filled via eSQL?

 

Kind regards,

Luna

Outcomes