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:
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.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.