14 Replies Latest reply on May 10, 2016 2:35 PM by BruceRobertson

    Creating a new record deletes / overwrites an old record.  Help!

    afletch

      Hello Community,

       

      I'm getting a really strange problem in one of my layouts.  Hoping someone knows how to fix this!

       

      When I add a new record, the layout deletes an old record. 

       

      The deleting is happening in the order of the primary key.  The table has 78 records.  When I add a new record, the new record has serial number 79, but the record with serial number 1 is now missing.  If I add another record, it will be number 80, and serial number 2 (along with all the data in the record) will be missing.  I've tried this several times to understand the behavior, and each time a record is deleted.

       

      Any insight would be much appreciated!