Autonumber within records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil M - 26 Oct 2005 14:00 GMT

I have a record database linked to a name only.
Within the records I want to add issues (which is linked via subform) this
works fine
but my question is this - does anyone know how to make it so the autonumber
works and resets itself for each record?

I have tried it but if i use Autonumber 1-8 on record 1 and then go onto
record 2 it starts with 9? whereas i want all records to start with 1.
Is autonumber the best choice for use or is their another method that would
get those results?

Thanks,

Neil

Reply to this Message

BruceM - 26 Oct 2005 14:12 GMT

You have no control over autonumber. There will be gaps in the sequence.
You cannot reset it to 1, at least not while there are other records in the
table. Without knowing more about your database's purpose it is difficult
to say if another method would yield better results. What do you mean when
you say you have a record database? Vinyl records? Database records?
Linked to what name? Issues?
If you have numbers 1-8 in the autonumber field, you have eight records.
Sounds to me like you could be treating the database as a spreadsheet, but
that is just a guess. More information is needed.

>I have a record database linked to a name only.
> Within the records I want to add issues (which is linked via subform) this
[quoted text clipped - 12 lines]
>
> Neil

Reply to this Message