AnsweredAssumed Answered

Filtering Value Lists

Question asked by JasonHyde on Nov 5, 2009
Latest reply on Nov 5, 2009 by philmodjunk


Filtering Value Lists



I would like to create a drop down list that only populates with related values that match certain criteria.

How can I do this?

I have looked at the other examples in the forum, but can't figure out how to do this myself!


I have records that look like:


FieildID Volume 

Code1 1

Code2 0.4

Code3 0

Code4 0.5


I would like to populate a drop down box via a list so that 'only' values in FieldID that have Volumes > 0 in it, i.e. in this case I should only have Code1,2,4 in the drop down box. These fields are already related in a 1-many relationship (as the Codes are unique), but I can use that code many times (until its volume value drops to 0).


I will then run a script on commit to update the Volume field, such that if I enter 0 it drops off my managed list.



Any help would be greatly welcomed.