Autonumber Restart

[aharding]

Is there a way to Autonumber (ex 1, 2, 3 etc) but have it reset to start again at 1 on the change of two fields? Ill try to explain..

A, B, Sub 1
A, B, Sub 2
A, B, Sub 3

C, D, Sub 1
C, D, Sub 2
C, D, Sub 3
C, D, Sub 4

A, D, Sub 1
A, D, Sub 2
Etc....

Is this possible?

[NeoPa]

I'm pretty sure not.

Open to contradiction though.

[MMcCarthy]

Essentially nothing can be done with autonumber. It is generated by Access and can't be manipulated. Whenever I want to set my own incrementing number I do it programmaticall y in VBA. However, what you want to do sounds very complicated and I would suggest that you look at your table structures again for a better approach.


If you want to give us some more specific information on your structures, what you are trying to do and why we will try to help you.