So setting the environment first.
List A - Item Request Field 1 - Request Item Name (Single Line Text) Field 2 - Current Requirements (Lookup field from List B with multiple selections allowed)
List B - Requirements Field 1 - Requirement (Single Line Text) Field 2 - Requested Item Name (Lookup field from List A)
So the workflow I have works like this. When someone enters an item into list B, the workflow will go to List A find the matching Request Item Name and add the Requirement to the Current Requirements field. That's okay works fine.
However if another item is added with the same Request Item Name it'll overwrite what is in the Current Requirements field, even though it's set to allow for multiple selections. How do I keep the workflow from overwriting? I need it to add it to the field so that all requirements are listed for each item.
On a side note if used a multi-line text box with "append" it did list all the requirements but removed the hyperlink. I would like to keep the hyperlink function.
So I either need: a) The lookup field to add more entries when the workflow is triggered