Unique ID creation

[Rude Awakening]

Hi Guys


New to the forum :-)

I'm trying to create a user story DB and need a Unique reference as a Field.
It is currently as a text field, I want it to be in the form of [Field1] & “-” & [Field2] & “[Autonumber]”
I need the autonumber to index IF Field1 and Field2 match. and if not to restart at 1.
Can this be done?

[John_G]

No, I don't think so. An autonumber is just that, "auto". It is incremented as soon as a new record is inserted into the table, which happens as soon as any data is entered into the record, and the number cannot be changed once it is generated.

The only way to reset it to 1 is to delete all data from the table, and then do a compact and repair.

You will have to use a numeric integer field, combined with a little VBA code to accomplish what you want to do.

John