Hot answers tagged workflow
You could add another column to the Sales list. Call it SupplyIDArchive. Make it a number, default 0, and use custom InfoPath forms (or whatever method you prefer) to prevent users from changing it directly. When a user makes a change to the lookup field, check if SupplyIDArchive is 0. If it isn't, change the item in the Supply list with corresponding ID to ...
Only top voted, non community-wiki answers of a minimum length are eligible