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!

Outcomes