I have 5 fields a b c d e and F.
b is containe YES or NO
c is number validation auto generate start with 00001
d is contained DOG, CAT, or CHICKEN
e is contained Number of animals
f is contained LIVE, DEATH, or SICK
in a I lke to have result like this:
- if b is YES then enter Y00001
- if b is YES and d is DOG then in a is Y0001D
- if b is YES, d is DOG and e is 2 then in a is Y00001D2
- if b is YES, d is DOG, e is 2, and f is SICK then in a is Y00001D2S
Please help I haven't done this before... Thanks in advance
b is containe YES or NO
c is number validation auto generate start with 00001
d is contained DOG, CAT, or CHICKEN
e is contained Number of animals
f is contained LIVE, DEATH, or SICK
in a I lke to have result like this:
- if b is YES then enter Y00001
- if b is YES and d is DOG then in a is Y0001D
- if b is YES, d is DOG and e is 2 then in a is Y00001D2
- if b is YES, d is DOG, e is 2, and f is SICK then in a is Y00001D2S
Please help I haven't done this before... Thanks in advance