AnsweredAssumed Answered

Filtering Value Lists

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

Title

Filtering Value Lists

Post

Hi,

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.

Cheers

Jason.

 

Outcomes