AnsweredAssumed Answered

Calculation Field

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

Title

Calculation Field

Post

     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:

     Abstinent

     Asexual

     Bisexual

     Heterosexual

     Homosexual

     Questioning

     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.

      

Outcomes