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
|
|||
|
|||
Using Autonumber as PK, cascade update doesn't work?
Greetings all,
I've been searching and searching and trying different things and I finally need to ask. Is it possible to use an Autonumber PK to cascade update new records? For example, I have three tables, let's call them Main, Sub1 and Sub2: In Main I have an Autonumber PK field named MainID. In Sub1 I have an Autonumber PK field named Sub1ID, and a Number field MainID. In Sub2 I have an Autonumber PK field named Sub2ID, and a Number field MainID. I have set up a one-to-many relationship between Main and Sub1, using the MainID field. Ref. Integrity Enforced, with Cascade Updates checked. I have set up a one-to-one relationship between Main and Sub2, using the MainID field. Ref. Integrity Enforced, with Cascade Updates checked. So when I enter a new record in the Main table, I want that MainID Autonumber to cascade update into the MainID fields of Sub1 and Sub2. I don't know if it's not working because it's a new record and Cascade Update only works if you *change* an already existing record, or if it doesn't work because it doesn't like my Autonumber. If anyone has the key to this I would be eternally greatful. I've tried everything I can think of on my own, and from browsing here, Access Help, etc. Thanks very much! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please Help?? Auto Update Field in table | A. Smart | General Discussion | 8 | February 2nd, 2006 01:19 PM |
how do I get autonumber function in access to work | Katharine Jansen | General Discussion | 6 | August 5th, 2005 03:36 PM |
Cascade Update Related Fields Bug? | Mike_iDbM | Database Design | 2 | December 27th, 2004 09:37 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Update links does not work. | Metallo | Links and Linking | 1 | August 7th, 2004 09:01 AM |