I threw together a demo file to show how I see myself using the ExectureSQL() function. The file includes a handful of custom functions that take parameters and create a valid SQL statement. The file shows how to take a search global field and find a matching record in another table.
I'd love some feedback on the concept, the functions, and the execution.
Wing Forward Solutions, LLC