dynamic dropdown box from a calculation?

[cbesey]

I'm trying to dynamically populate a dropdown list of current salespeople from a "Display Name" field in another file (the dropdown resides in a portal). The hitch is that there could be many people with the same display name - some current salespeople, some former (identified by whether they have an Employment End Date). In other words, in the dropdown, I'm trying to display all of the salesperson's Display Names, but only if they have a null Employment End Date.

Any thoughts on how to get it to update dynamically? I thought about using a calculated repeating field for the value list, but am not sure if I'll exceed the max number of repititions (I'd need about 40). Plus you can't have a calculated global...

Kinda stuck and need a push...

Thanks!

Chris

[Leb i Sol]

this post belongs into forum Value Lists......and there u will find your answer...search for "Dynamic Value Lists"

take care!