AnsweredAssumed Answered

Delete data from a Looked Field

Question asked by brzasa on Oct 19, 2013
Latest reply on Oct 23, 2013 by philmodjunk


Delete data from a Looked Field


     I have a relational DB's Recipes, Ingredients. In the Recipe Card DB I have the Fields - Ingredient and Ingredient_Shortname.

     When creating a new recipe, I add ingredients in repeating fields in the Recipe Card DB from a value list of ingredients in the Ingredient DB. The Ingredient_Shortname field is also a related Look-up which fills with an abreviation. This all works. I'm having trouble reversing this process. Let's say I have one too many spices and want to remove one. If I delete the value from "Ingredient", the previous Looked up value in "Ingredient_Shortname" remains. How to I get data in the related field to delete automatically?