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?