Field Change Question
Field Change Question
HI need some help!
I have a field (Category) that is a drop down box with category names. (Kitchen, Bedroom, Garage, Garden)
I have a hidden number field (Category_Code) which has category codes (001, 002, 003, 004)
I would like the hidden field to be updated with the correct code based on the choice selected in the drop down category name box. So choose bedroom and category code will = 002
Can this be done with script?
Martin