Value list based on individual field values

[chevell]

I have a list of users and each has a field for either director or vp. I want to built a value list for both. In otherwords, I want one list with only those whose value is "yes" for vp and the same for director. I was assuming I could use some sort of self relationship, but I don't see where to make the relationship that specific. Ideas? Thanks!

--

Chevell

[Tim W]

Create a static field with the text value = "Yes".

Use it for one side of the relationship and your target for the other.

example: triger type text calculation ="Yes"

TO = directors list

file;triger = file;directors

you can use the same triger for both self-relations.

HTH

Tim

[chevell]

Ok, I think i'm missing something here.

I don't quite follow your meaning. Can you elaborate?

Thanks!

[Tim W]

Sorry it took so long to get back to you. Maybe this file will help explain better than words.

valuelistexample.zip

[chevell]

Awesome! I finally got this to work. Thanks a bunch. NOW, how do I get the list to work in another database? I have a bunch of databases that use the USER database for lookup and would love to be able to select director and VP in each of those databases for the given record.