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

Is this possible?

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. :(

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