In message ,
jerseygirl writes

Recently, I’ve discovered that this is not how AutoNumbers should be used,
and I’ve wound up needing help from this forum. I’m going to create a new
database to start at the beginning of next year. What should I do so that my
invoices show up in the order I enter them? Can I somehow make it so that
each record gets timestamped when I create it (not as Primary Key), so they
stay in order? Is there a way to use AutoNumber for this safely? Or is
there something else I should be doing?

You can add a date field with a default value =now() which will
timestamp each record. On the other hand, an autonumber field does the
job so why change anything?

Have you consider a composite primary key composed of supplier ID and
supplier invoice-number?



--
Bernard Peek