AnsweredAssumed Answered

Unable to modify options for table field pkey

Question asked by lfnunley on May 31, 2016
Latest reply on May 31, 2016 by beverly

Hello all,


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!