August 7, 201312 yr This one has got me flummoxed. Using the ODBC driver, I am able to view, make relationships etc with my SQL online database and Filemaker. Within a typical SQL app such as Sequel Pro, I can create a new row (record) quite easily. This involves the auto creation of a 4-digit ID. The problem is, I cannot perform the same task within Filemaker. The crucial field (Product_ID), has non modify attributes, and as such, throws up an error during a new record creation script. Is there a solution via the Execute SQL script? Eric
August 7, 201312 yr Automatic message This topic has been moved from "External Data Sources" to "FQL or FileMaker Query Language".
Create an account or sign in to comment