Validating data by another field.

[lonesomejubilee]

Hi,

I have a drop down list of about 5 options.... how do I make it so that if the user chooses a certain option... option a, then the other field (money) will automatically be set to zero and cannot be changed? I tried going through validation but I may be misunderstanding that because it seems that it only validates that field on specified criteria, not based on another field.

Thanks.. VANDY

[-Queue-]

Make money an auto-enter calculation of Case( field1 = "a"; 0; money ), and deselect 'Do not replace existing value for field'.