In this video, Martha Zink shows one way to take advantage of the ExecuteSQL function in FileMaker 12. By using the Virtual List Technique along with the ExecuteSQL function, a Main Menu layout can show dynamic buttons based on a unique list of categories in a table.
About The Author
Martha Zink
Martha has developed in FileMaker since 2004 and has spoken at the FileMaker Developer Conference as well as multiple FileMaker roadshows. Her passion is helping people solve business problems and have happier work days. If FileMaker doesn't have Martha's focus, then she is either photographing everything around her or cooking up a storm in the kitchen. She's a mom of two kids, who will likely have no choice but to learn about databases, relational design, and scripting at a young age.