Number Subforms

[Rachel Ruta-Wappler]

I have created a filing system for our folders. Have set
up the auto numbers for the folder okay, but can't get the
numbers to start at 1 for each of the documents in each
folder without creating a new table for each folder.

I have seen this done before but can't remember the code
for it.

So basically I have 1 - 10 folders and in each folder I
have 1 - 10 dividers with documents for each divider which
I would like to start at 1 and increment from there.

Can anyone help.

Thanks

 

[Hugh O'Neill]

I have created a filing system for our folders. Have set
up the auto numbers for the folder okay, but can't get the
numbers to start at 1 for each of the documents in each
folder without creating a new table for each folder.

I have seen this done before but can't remember the code
for it.

So basically I have 1 - 10 folders and in each folder I
have 1 - 10 dividers with documents for each divider which
I would like to start at 1 and increment from there.

Can anyone help.

Thanks

Don't use Autonumber for this.

Autonumber is designed only to provide a unique identifier for records
in a table. This is used internally by Access in building relationships
between tables according to your design. The actual values that
Autonumber delivers are unimportant and should never be exposed to
users or have any external meaning at all. Depending on the design and
use of the database, Autonumber will develop gaps, become random and go
negative.

For any number series that you want to control or have available
externally, you must design your own. There are several schemes
available depending on what you want to do.

hth

Hugh