Cascading Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I'm struggling with Access....
I'm in the process of creating a database and I wish to use the forced
integrity feature for related tables as I would like to make any neccessary
adjustments in one place to ripple through the rest of the database
automatically...

This is all well and good when I already have the related fields created in
the first table and the related table - I've tested it by changing the
original field, and the related field changed too...

But I would like to add a new filed to my original table and have that new
field automatically added to all related tables in one shot...is this
possible without having to resort to VBA code in the background? Am I not
seeing a basic option somewhere to automatically perform this function?

Thank you in Advance, and just a note to say You people who are spending
your time here to help others are Kings and Queens among ordinary people in
my book.
That's very human of you!

: ) C
 
You may be misunderstanding the purpose of Cascade Update.

It's intended solely for the purposes of ensuring that an update gets
propogated to all appropriate places.

An addition is not the same as an update: Cascade Update does nothing for
additions.

In general, you don't want to create "automatic" entries anyhow: you only
add "child" records when you have something legitimate to add, as opposed to
having placeholder records created that you can later set to their correct
values.
 
There is no way to have Access automatically add new records to other tables
when you add one to the "Master" table.

You will have to use VBA code in a form to do this.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top