Changing a Case Name

B

binder

Hey guys -- I have a form CaseSteps in which I have a drop down combo box to
select a CaseName for the step. The list of CaseNames is in it's own table.
Is there a way where if I change the case name, it would then change it for
all of the CaseSteps that have been created?

Thanks
 
J

Jackie L

If you create a relationship between the tables using referential integrity,
cascade update, it will automatically change in the cascading tables.

If you are doing this off a form, based off the table of CaseNames, you can
add an event to the After Update of the CaseName where you would run Update
queries to Update the value in the tables affected. You would need to be
careful with saving the old value and the new value since the After Update
would be off the new value.
I would tend to want to set up a form which would be a Utility to change
CaseNames and the user could populate unbound fields for Old Name and New
Name. Put a button to run the update queries. The Update queries would then
use those fields as criteria (Old Name) and as update value (New Name). In
this case, you would need to update the original CaseName table also.

Please let us know if you need more specific information.
Jackie
 
K

Klatuu

This is what autonumber fields were created for. If you had the relationship
set up using primary and foreign keys that are autonumbers, the text in the
description field doesn't matter. In this case, when you change a case name,
it has to be changed only in one place.
 
Top