Does not update

[SteveI]

Hi,

I want the attached database to update automatically. I.e. when I change the description of the ingredient from Sugar to Brown Sugar In the Ingredient Table - I want all the recipes that contain sugar to change descriptions to Brown Sugar in the Recipe/RecipeIngredient Table.

Is this possible. Find and Replace is not an option. Update Query is not an Option - as it will be a user database and writing a query is too sophisticated. Find and replace is too risky and basic.

Any suggestions please..

Contains code to update description field as code is entered.

 

[SteveI]

thanks but does the subform in the main form not lookup the ingredients in the ingredients table already. or is the lookup table something totally new - can you be more specific.

 

[RainLover]

Steve

Before I got past your initial post I was thinking the same as the man from Uncle Gizmo.

 

[gemma-the-husky]

I agree with uncle gizmo - store a numeric code, not the text value

however - another alternative is to define all your relations (particularly those involving the ingredient description) with relational integrity, and set cascading updates. then when you change the ingredient name, all the matching items will change as well.

copy the dbs first, just in case