I'm very new to FileMaker with some coding knowledge. I'm trying to use FileMaker as a Front End app for our SQL server. I was successful with connecting to our SQL server and configuring some custom screens to display search outputs from SQL server. I have to say that it works great and the search is instant!!
I'm trying to figure out a way to add a row to our "comments table" in the sql DB. I started to read about execute SQL statements but i'm having issues with understanding the concept. Is possible to setup a form which after filling out will have a button to "Add Comment" which will insert the row in the sql DB.
I hope that what i'm describing makes sense.