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!