Where do I put my ExecuteSQL calculation?
Do I create a new field the table that I want to query in and use an autocalculation where I use ExecuteSQL? Or do I create a new layout where I can put my query fields as I continue to select various pieces of data? I find it confusing to wrap my head around where I put my ExecuteSQL statement because it will only produce a single result of text. For a simple example I want to find the distinct values in a field called 'Tray Name'. How and where do I do this?