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:
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.