Field dependant on other field

[jamphan]

I have a ddlb called FieldA with multiple choices. I want to have another filed, FieldB that will return a numeric value based on what is in FieldA. For example if Red is selected from the DDLB I would like Field B to have a 1. I am thinking that a Case Module needs to be done but how is can I get fieldB linked to FieldA? Field B needs to be linked to a table field as well. Thanks for the help.