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?