solve this

[vivin007]

i have 2 fields one is "religion" (text) and the other one is "Parish or horoscope" (text).I want a calculation so that if i type "christian" in the field "religion" then the field "Parish or horoscope" should be automatically typed with "Parish" and if i type "hindu" in the field "religion" then the field "Parish or horoscope" should be automatically typed with "horoscope"..

can any one help me please..

[Zcast]

Try this. They're are other ways to do this also.

religion.fp7.zip

[zazen]

Redefine your "Parish or horoscope" as a CALCULATION field with the RESULT being TEXT and the following as the calculation (you can copy and paste it)

Case(religion = "christian"; "parish"; "horoscope")

This calculates for the 2 results you wish for. The above function operates, in plain English, as "if this person is a Christian then this field will be PARISH. Otherwise it will be HOROSCOPE".

You can add to this if you wish. Let's say you wanted to add Buddhist with the result "dharma". Your function would be as follows:

Case(religion = "christian"; "parish";

religion = "hindu"; "horoscope";

"dharma")

Hope this helps!

[vivin007]

Thanks Dude

[vivin007]

Thanks Dude....... :yourock: