Hi, I'm a Filemaker noob. I hope this is the correct forum to ask a technical question, it seemed like the right one. Anyway I'm in a position now where I'm having to learn Filemaker. I've got a few books, but a lot of the time I can't quite grok what I need to do to make something happen.

My current problem is that I'm working in a fairly complex database, and for one of the reports that runs it references a calculation field to determine which data to include in the report. The calc field uses a Case function, and it looks like this:

Case( ItemType = ""; " "; ItemType = "Ads"; "Yes"; "No" )

So it looks at a field called ItemType to see if the value is "Ads", and then the script it's running in slugs "Yes" into the calc field which causes the related data to show up in the report. If the value is not "Ads", then the related data doesn't get included.



What I need is to know how to modify that code to allow more values than just "Ads". For example I would like it to match "Ads", "Ads 4c", "Ads 2c" instead of just "Ads". Since my calc knowledge is basically nonexistent, I don't know how to make it do what I want. I've tried a bunch of things and nothing has worked. For example I tried:

Case( ItemType = ""; " "; ItemType = "Ads" or "Ads 4c"; "Yes"; "No" )

And that didn't work. Can anybody help me out with this? I just don't have a frame of reference for what I'm trying to do, and I don't understand the way calcs work enough to make it happen. Thanks for any help.

Try this:

Case( ItemType = ""; " "; ItemType = "Ads" or ItemType = "Ads 4c"; "Yes"; "No" )

That worked!

Thank you so much. It seems so obvious now that you've shown me how it works. Very much appreciated!