Hello All,
I’ve been playing around with moving data between tables using CSV files. I have discovered that restoring data to an auto-increment field is problematic.
Is it possible to manage the auto-increment value in a table?
Hi Tim,
That’s a great question and thank you for sharing! Auto increment values are immutable. Therefore, you will not be able to map to any fields in your table that are of this type, such as formula fields.
Please don’t hesitate to reach out to our support team if you have any further questions! 
Les,
Thanks for the quick reply!
So, from a disaster recovery perspective, I guess using auto-increment fields are not ideal.
Would it be best to design a table utilizing a next-number approach (in a separate table) combined with form rules?
Thanks