Default data in a Field based on the data in 2 other fields in EC

[BaldeepS]

Hi Experts,

I have a requirement to default the values in field 3 based on the selections/values in field 1 and 2 probably something like a one to many and many to one relationship between 3 picklists on JobInfo. Any suggestions on how this can be addressed will be helpful. I wasnt able to create a business rule nor did I succeed in creating an association. I know that this can be done via a lookup but I am looking for any other way to solve this.

Example:

Field 1 (picklist) - A, B, C

Field 2 (picklist) - 1, 2, 3

Field 3 (picklist) - A1, A2, A3, B1, B2, B3, C1, C2, C3

Thanks in advance.

[nlgro023]

Did you try an onchange rule (set on field 1 and 2) with all scenarios that then fills the third field?
If Field 1 is A and field 2 is 1 then set field 3 to value A1
etc.
Maybe even set it as onsave as well just to be sure it does the job