2 Replies Latest reply on Dec 20, 2014 2:35 AM by disabled_Luna.media

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

      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