Value List from Multiple Lists?

[Ext285]

I am stumped by this one and am wondering if any of you out there in cyberspace might have some suggestions.

I have three databases and in the third I want a field to show a popup menu listing values from a value list in database 1 and all the values from a value list in database 2. The values of the popup list are not conditional...just show all of the field values from field TextValue1 in Database 1 and field TextValue2 in Database 2.

I have no problem setting up a value list to show the entries that have been made into TextValue1 and I have no problem setting up a value list to show the entries made into TextValue2. Just can't figure out how to show all the entries from either TextValue1 and TextValue2 on one singular valuelist.

:

Any ideas?

[Fenton]

A Value List using values from a field is reading from the index of the field, which can only exist in one table. So it is not possible to have values from 2 separate tables (not to mention files) in the same Value List.

The only way it could do that would be to somehow get all the unique values into another field in a single table. This could be done via a script, triggered by "on field exit" plug-in action. There is a free plug, zippScript, which can do this. It would need to be attached to the 2 fields in the 2 tables (files). You would first import all the values, to get the bulk of it done. Then it would be pretty quick, as it would only have to check for, and add one value at a time. All the values could go into a single field in a single record, or it could be multiple records.

You would have to decide whether to also remove values. This would be (much) more difficult, as record deletion in the other tables might remove the only remaining instance of a value.

Another (clunky) alternative is to put your field on the layout twice, once with one value list, another with the other.