Generating ID Numbers for new records

M

melwester

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

CTAMain
Autonumber
IDNumber
CTAName

CTA Contacts
Id Number
Name of Contacts

Regions
Id Number
Name of Region

CTANotes
Auto Number
ID Number
Comments

MemFirmView
AutoNumber
IdNumber
MemFirmID

MemberInfo
AutoNumber
MemFirmID
FirmName

MFirmMain
AutoNumber
MemFirmID
Address
etc.

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