Design Dabbler

Show link to all items of other List with same ID


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?


0 Kudos