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
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