2 Replies Latest reply on Jun 9, 2016 2:31 PM by user26705

    Scripting Field Updates

    user26705

      I am looking to do something similar to the following when the user clicks on a button on the screen:

       

      "Update tblCampaigns Set tblLeads = tblLeads + 1 Where tblCampaigns.CampaignName = tblLeads.CampaignName"

       

      I have tried to do this by using Execute SQL and ExecuteSQL() but have learned that those are not the right approaches or I am not doing it right.  BTW, the tables in the above statement are all FileMaker tables and no ODBC data sources are involved.

       

      This script will also execute other operations and I there is not portal being used or permitted in the UI design.  Any suggestions on how to make this happen - would be greatly appreciated.  I realize I might not be able to use SQL, although would love to, but hoping to learn the best approach for this in FileMaker.

       

      Thank you in advance!