I have the following Problem:
List A is a List with open Purchases.
List B is a List with the pending getting quotes.
Purchase 1 has for example 4 related processes in List B.
Now i want to have a field with all links of pending processes that are related to purchase 1. Of cours i have a coloumn that shows the information to which purches the quote belongs, but i need all of the links in just one field in List A. And it hast to update automatically when an item in list b gets updated.
As well, i need to get a information immediately when for a entry in List A there are no more items pending in List B.
How can I achieve this?