REPOST - I need to make the IDNumber an Autonumber - HOW??

M

melwester

I have 8 tables. We want to make the ID Number & MemFirmID an automatic #.
The table structure is this:

tbl_CTAMain
Autonumber
IDNumber
CTAName

tbl_CTA Contacts
Id Number
Name of Contacts

tbl_Regions
Id Number
Name of Region

tbl_CTANotes
Auto Number
ID Number
Comments

tbl_MemFirmView
AutoNumber
IdNumber
MemFirmID

tbl_MemberInfo
AutoNumber
MemFirmID
FirmName

tbl_MFirmMain
AutoNumber
MemFirmID
Address
etc.

tbl_MemFirmNotes
AutoNumber
MemFirmID
Comments

When adding new records we want to keep the IDNumber & MemFirmIDNumber
incrementing by 1.
How would I do this without having to recreate the whole database? They
are all linked via IDNumber as I have an unbound combo box on a form.

Thank you.
 
K

KARL DEWEY

I can not figure the relations between your tables. Which table do you want
the ID Number & MemFirmID an automatic # for?
 

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

Similar Threads

Generating ID Numbers for new records 0
Something hard turned out to be easy! Can you guess how? :) 19
Changing the Autonumber value of already created records 6
convert a number to an autonumber 4
How To Change AutoNumber Format 3
I cann't fill in a subform 1
Adding autonumber to a non autonumber field 2
How to select the first combobox item (ie. Set Combobox.ListIndex = 0) 2

Top