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.
 

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

REPOST - I need to make the IDNumber an Autonumber - HOW?? 1
DB Design Question - Nearly identical records 2
Increasing number in Customer ID field with existing records 3
Autonumbering Old Records 2
Add New Records Based on Value in Text Box 1
automatically generating a new record from two records in another 0
Automatic ID Number 6
Adding new records in subform under the same ID 1

Top