Conditional Value List based on a Second Field's Number

[dragonmaster]

I am a newbie and think that this is what I need to solve the task. I believe that it is a conditional value list, but am not sure.

Here is the problem. I am grading assignments. Each assignment has various components with different values. For example -- Project Specifications 10 point max. I have two fields Value and Points. I set value to 10. I then need a drop down value list for Points 10,9,8,7,6,5,4,3,2,1,0.

Each component could have a max value that is different. I am currently using a set value list from 50 to 0, but it is time consuming when you have a max for this item of 10. It is also does not make it user friendly to share with another teacher who could easily award more than the max available for that component.

If a conditional value list is the answer, how do I create it so that it takes the number from Value and creates a list from that number down to 0. I think this would need a script and loop to create this type of list.

Any help will be appreciated.

Thanks,

Michael

[Vaughan]

I'd set up field-level validation that requires the "points" field to be less than or equal to the "value" field. you could also validate that the "points" has to be a positive integer as well.

Once the validation is set up, the user cannot enter an incorrect value and save the record.