Hi @Alex_Koch - there doesn’t look like there’s an automatic way to do this, but there is a workaround:
- Duplicate the base (with all of the current records)
- Duplicate the table(s) you want in the new base:
- When you duplicate select “off” or “no” for “Duplicate records”:
This will give you the table structure you require, but without any records (obviously) and when you enter a new record in the duplicated table, it will restart at 1 again:
Weirdly, if you duplicate the whole base (and don’t carry over records) the autonumber does NOT reset, so you need to do it table by table (then delete the original tables).