AnsweredAssumed Answered

How to use multiple fields from one record in a value list

Question asked by berts on Dec 3, 2014
Latest reply on Dec 29, 2014 by berts

What do is the case:


Table: language

Records: one

Filelds: Up to100, from field a001 ~ a010 ......... z001 ~ z005 + a field "id_language"

Field type: Gobal

Field Content: looked up and one field "id_language" which gets a variable ($$id_language) entered by a start up script.

Relationships: 6


What I am looking for is a way to fill value list with a range of fields from the only record in the table "language". However the Value list options don't allow more than one field to be used from a particular table.


I need something similar to the "Use value from field" option in "Edit value lists" but than like this: Use value from fieldS, instead of field


The purpose is to create a value list to choose from in the right language in a couple of tables.


Any idea's?


Thanks in advance


Bert Stolker