Roger Carlson has simple solutions for both single and multi-user
environments at:

http://www.rogersaccesslibrary.com/forum/topic395.html

while my slightly more complex solution at:

http://community.netscape.com/n/pfx/...g=ws-msdevapps


also allows the number to be 're-seeded' with a number at which the sequence
will re-start when the next record is added. This could be adapted to re-
start the sequence with your number from another table.

Ken Sheridan
Stafford, England

Bre-x wrote:
I coundn't find what I am looking for, most of the instructions are to reset
the autonumber.
I am looking for a way to auto increment a field.

After a few hundred records have been inserted I need to find a way to auto
increase the
main_receipt starting from a number in another table.

Help!!!!!!

Bre-x

If you are using Access' Autonumber data type, be aware that it is ONLY
designed to provide a unique identifier. It is not guaranteed to be
[quoted text clipped - 28 lines]

Bre-x

--
Message posted via http://www.accessmonster.com