I need to know if 1. It is possible to code a wildcard statement in FileMaker Pro. 2. Write a case statement that supports 3 or more conditions (for those of you who write sql code you will know what I am talking about) I have inherited code that I am not familiar with. This (Sales) process has been around since 2004 and I joined this company in the summer of 2011. I never heard of Filemaker until 2011 so please bear with me. I have attached the actual table that I am using and needing the case statement for. I also need to know that once a row is updated with the case statement, how do I write a loop for it to automate all of the process. anyones help would be appreciated.