I have two lists. The List 1(tasks) has a drop down field that when set to In Progress creates an entry on List 2(suggestions). If any of the entries on List 1 change to Final status the corresponding item on List 2 needs to update.
I saw a previous answer to a question like this:"When you create item in list 2 keep a lookup column pointing to ID for list1. So when any changes are made to list 1, search for the item in List 2 with column values as List1_ID. This approach will work if you have only 1 item in list2 corresponding to list1."
If this is the correct answer then can someone provide me with screen shots to walk me through this? If it is not the correct answer can someone provide one? I would still need an example please.