Adding autonumber to a non autonumber field

D

don

Hi Group,

Hope someone can point me in right direction.

I have an address table which uses a custom number to define an
address location. It is based on location and is not auto
incrementing.

I've made a form for adding new addresses and want to assign a
temporary autonumber to the address when saved as the user will not
know the geographical number to use, and as an aside we need to be
able to distinguish new address added for verification.

At present I have the detail appended to a New Address Table where it
gets its autonumber, but I* think it makes it messy when trying to tie
that back to the contact.

I guess I could append to new table pick up autoid append new address
table to address table and then delete new table contents, but that
seems like a long way round.

I'm not that new to this anymore but it seems I still don't know
much. Any help would be appreciated.


Don
 
G

Golfinray

You can do a query. In design view of a new query, designate it as a
make-table query and go to sql view and type:
Alter table tblname
Add column autonumber counter (1001,1)
Run the query and it will add an autonumber column to your table. You might
want to try this procedure first in a _temp table to be sure of what you want.
 
D

don

You can do a query. In design view of a new query, designate it as a
make-table query and go to sql view and type:
Alter table tblname
Add column autonumber counter (1001,1)
Run the query and it will add an autonumber column to your table. You might
want to try this procedure first in a _temp table to be sure of what you want.












- Show quoted text -

Many thanks for your suggestion, I would prefer however not to have
to have an extra field if I can help it (though in the scheme of
things it may not matter) as I already have 601000 address records and
will only need to add a small number of addresses.

Thanks again though

Don
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top