I have a table with a series of text fields that indicate if a person/company is a particular contact "Type" (I sure wish FileMaker had boolean fields). I need to build up another field in the same table with a calculation that would go like this:
If ( Cash = "Yes"; FilterTypes = "C"; FilterTypes_Current = "" )
if ( Item = "Yes"; FilterTypes = FilterTypes + "I"; FilterTypes = FilterTypes + "")
if ( Bookstore = "Yes"; FilterTypes = FilterTypes + "B"; FilterTypes = FilterTypes + "")
FileMaker will not allow me to put the multiple if statements in the calculation block.
This aren't nested ifs but they each stand alone. I need to end up with a text field that has a one character identified for each type that has been checked as yes. Each type stands alone and none are mutually exclusive. They can all be checked or none.
How do I do this?
Thanks in advance. This is my first post to Experts Exchange.