If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
REPOST - I need to make the IDNumber an Autonumber - HOW??
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. |
#2
|
|||
|
|||
I can not figure the relations between your tables. Which table do you want
the ID Number & MemFirmID an automatic # for? "melwester" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with AutoNumber | accessmonk | Database Design | 2 | September 30th, 2004 08:57 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
MAKE QUICK CASH RIGHT NOW!!! 100% LEGAL, INSTRUCTIONS IN THIS POST!! | MAKE CASH NOW!!! | Setting up and Configuration | 0 | December 12th, 2003 06:36 PM |