Through a lookup request, I type a word in field 1 and a phrase in inserted in field 2. Now I delete a word in field 1 and the phrase is deleted in field 2.
I type in the word BLUE in a field named COLOUR and in another field named DESCRIPTION the words THIS IS THE COLOUR BLUE is pulled via the lookup from another table.
My question is, If I delete the word BLUE, I want the Description words to be deleted as well.
How would I be able to accomplish this?