I have a database in Filemaker 12 Pro Advanced which is connected via ODBC to a Microsoft SQL database. In most of my tables I have the pkey being auto-incremented by SQL. I have one table which for some reason is set in Filemaker to be an auto-enter serial, even though in SQL it is an identity primary key. This means I am unable to add entries to the table in Filemaker because I get an error from SQL about filemaker trying to insert a serial.
I can not modify the field options to turn off auto-enter for some reason, even though I can modify all of my other fields. The actual options button in the 'Manage Database' window is greyed out.
Any ideas? Thank you!