Value List across Multiple Tables

[Corey-Troy]

Is it possible to have a Value List, to list data from several Tables of records?

I have several related Tables, but i wanted to place a value List on a field, that will contain data from several other tables, not just 1 or 2.

[Matthew F]

If you have two value lists ('Value List1' and 'Value List2' that reference two different fields ('Field 1' and 'Field 2') you can combine them together in a calculation field like this:

ValueListItems ( Get ( FileName ) ; "Value List1" ) & ¶ &

ValueListItems ( Get ( FileName ) ; "Value List2" )

You can then reference this calculated field in a new value (Value List3) list that incorporates the contents of both Field 1 and Field 2.

[comment]

You can then reference this calculated field in a new value (Value List3) list

Only if the calculation is stored* - which I believe would defeat its purpose.

---

(*) There may be a workaround for that, but it would probably be better to fix the data structure.