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
|
|||
|
|||
Primary Key Cascade Question
In an Access 2007 db, I have 5 tables, with Proj_No the Primary Key field in
the main table tblProjID. It has 7 additional fields. It will be benificial to have Proj_No in the other 4 tables as foreign key fields. My question is, when a new Proj_No is entered into the main table to create a new record, how can I get that entry (alpha-numeric) to cascade to the other 4 tables, thus creating a new record in the 4 child tables. Thank you Marsh |
Thread Tools | |
Display Modes | |
|
|