AnsweredAssumed Answered

Calculation Field

Question asked by dscott23 on Oct 24, 2012
Latest reply on Oct 24, 2012 by dscott23


Calculation Field


     This is so simple..Hopefully, I'm just stuck on stupid.

     I have two fields in the same table.

     Field 1 is named Sexual Orientation and the value list entries allowed are:







     Field 2, (which I've set up as a calculation field) is named MSM (short for Men who have Sex with Men)

     I need the MSM field to auto populate with the value Yes when the Sexual Orientation field = "Homosexual" or "Bisexual"

     As we have the need to search for records where MSM=yes

     Thank You.