Hi Laura,

The Auto-Increment only appears when you initially create a list (see first attachment called "autoincrement.png").

Once you get past that initial page, you can never go back and change it.

This means that your lists cannot have the primary key changed to a different value. If the Primary Key Type was set to Integer from the start,

I've provided you with screenshots of two different lists, one using Integer as the Primary Key Type and the other list using the Auto-Increment Integer as the Primary Key Type.

As you can see, if the Auto-Increment option is used the moment the list is made, you will never get the option to edit that Key value in the UI or any place else. If the regular Integer option is picked at the moment of creating the list, then you get the box that allows you to change the Key value to whatever you want.

This is why I believe your lists were created using the Auto-Increment option. This is also the reason why your attempt at trying to update the Key value on all those records in the list didn't work (because the Key values were not editable to start) and why the deleteRows option wasn't working (due to trying to delete Keys that were invalid).

Does this make sense?

Regards,

Jon