022: ExecuteSQL Function Basics: free training webinar for FileMaker Citizen Developers

The ExecuteSQL calculation function is the most unique function in FileMaker's collection. It allows us to find and retrieve data or a summary result from a table occurrence even if no relationship exists between it and the current table occurrence context. We can use it in field definitions, charting, tooltips, certain script steps, anywhere we write calculations. In this webinar, I will show you the basics of incorporating ExecuteSQL into your calculations, how to write simple SQL queries, and how to avoid frustrating syntax errors that frequently accompany first attempts. Webinar led by FileMaker Certified Developer and Claris Training Partner, Tim Jones. If you would like to do the exercises along with Tim, download the FileMaker database file he used in this session: https://www.acceleratecomputertraining.com/downloads/fmGroupTherapy/AnimalCare_022.fmp12