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