Value list from another file?

[ErnieG]

Is it true that a value list based on a field in another file doesn't work in CDML? Anyone find a way around it? I have a "code" value list that is used to fill in three fields with "theme," "story" and "subfocus." When you change the code from the Web, however, only the first field is changed.

I tried creating three calculation fields to match the "code" field, and used them in three separate relationships for each of the fields. Changing the "code" field causes all three matching fields to be altered, but again, only the "theme" field is filled in correctly. The other two retain their old values.

Seems very odd. If anyone else has come up with a workaround, I'll be glad to hear about it.

Thank you.

Ernie

[VoidState]

[ORIGINAL QUESTION DELETED]

The answer can be found here.

V

[ErnieG]

Thank you, Mr. V

Looks good.