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

G

Guest

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

Guest

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

How do I make a multi-part autonumber? 5
how to include an Autonumber field in a make query 8
VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView 7
How do I make the Primary Key autonumber as date and time 3
Can I add a sequence / autonumber field to my Make Table Query? 1
Create a new record from an existing one 4
Changing unbound combo boxes to bound 4
changing Unbound combo box to bound combo box 2

Top