I have a filtered lookup field in a sharepoint list that displays a list of stores from another site in the same site collection and I need to know which region the store belong to which is part of the record. Home site list
**Store Region** Halifax Atlantic Toronto Central Calgary Western
Sub Site list for store requests
- Request type = inventory Store = from filtered lookup Region = ???
How can I get the associated region from the home site SharePoint foundation