AnsweredAssumed Answered

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

Question asked by on Dec 20, 2014
Latest reply on Dec 20, 2014 by

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,