Value list based on a dynamic list in a diff file

[straddeck]

BACKGROUND: In file One I have sales reps in which each rep has an <Active> field of either "Yes" or "No". In file Two I created a value list of sales reps whose <Active> field was set to "Yes". I did this by creating a global field populated with "Yes" and then creating a relationship between the global field and the <Active> field in file One. I then created a value list based that relationship.

PROBLEM: I want to use this active list of reps in many other files but when I define a new list (let's say in file Three) using the list already defined in file Two, I cannot get the values to show up. Do I have to redefine the list and relationship in each new file where I want an active list of reps?

[danjacoby]

Create a calc field in file one that returns the rep if the "Active" field says yes. Then base all the value lists on the calc field.