Access 2007 Validation rules -

i'm trying make field put name in when different field has text in access 2007. eg.

if [fieldname] = "mountain" [fieldname2] ="jack" if [fieldname] = "ocean" [fieldname2] ="john" 

i can't find expression give me result.

it's better change multiple if-then statements case/switch statements.

select case [product category]     case "children"         [category manager] = "john"     case "hybrid"         [category manager] = "jack"     case "leisure"         [category manager] = "sally"     case "mtn."         [category manager] = "kelly"     case else         [category manager] = "carl" end select