I have the following scenario that I am trying to get find a solution for.
I have two lists within my SharePoint site called Supplier and Factory. The relationship between the supplier and factory list is one to many, that is for each unique supplier there can be multiple factories that are related to it.
So in the factory list there is a ...