So i have 2 lists, a and b. some of the fields in list a such as envelope (dropdown) is based on a lookup reference. I'd like to create a workflow wherein if envelope 001 has been chosen, envelope 001 from the reference table will not be available anymore in the option. is there a way to. do this?
or can I create a rule wherein if envelope 001 is chosen, envelope 001 in the reference table will be transferred to list b?