value list from two fields in two different tables

[admiralpumpkin]

As the subject states, I would like to create a value list with data from two fields in two different tables.

Is this possible?

[CobaltSky]

Hello admiralpumpkin,

Welcome to the forums!

There is no native feature for the creation of compound lists. However it's possible to script the creation of such a list.

So if you require a drop-down list, for instance, you might define the field as a button which assembles a current version of the combined list prior to activating the field. :(

[sbg2]

I think it is, hopefully this is what you mean.... example attached.

In short:

1) create a value list of each seperate field you want to use in the combined value list.

2) create a table for the sole purpose of storing the combined values. Create a calc field in this table = ValueListItems("MyDBFileName";"MyValueListName1") & ¶ & ("MyDBFileName";"MyValueListName2").

* note: "& ¶ &" seperates the last value in the first list from the first value in the second.

3) Create a value list that is based on the combination calc.

Where I see a problem is adding or removing values from either field. The Combine field will not update since it can't be an unstored calculation and be used in a value list.. ugh. So I turned the entry field into a button (and disabled it from being entered in browse mode) that triggers a script that deletes all records in the Combine table and then creates a New Record, in effect refreshing the calculation. Maybe someone can come up with a better way to refresh the calculation.

TwoFields.zip