Complex lookup - lookup in lookup
Hi guys, I´m currently working a lot with SharePoint. I´m not a code expert or It specialist and I do everything with try and error. But currently I reach my limit – maybe you can give me a tip and help me. I work in my current Lists a lot with lookups. But with more and more requests that gets very complex. We have different contact persons for different Areas. We have a lookup column for Area A,B,C,D,E The next column is a Contact lookup – Area A contact 1,2,3 – Area B contact 1,2,3,4,5 and so on Is there a way that Area Column lookup affects the Contact Lookup? When in Colum Area is selected Area A – show me only contact options for Area A I hope I wrote it so that you all can understand it. Thank you very much!!!Cross Subsite lookup list
Hi We have an O365 SharePoint Online site collection with multiple sub sites of student data. Each sub site represents results of a set of students in a particular class from a particular year. I'd like to create a lookup list at the parent site level that displays all the results gathered from all the sub sites for each student. We can then filter that list for each student or each year etc. Can anyone recommend a method of doing this? I can't see how to easily query all the sub site lists and bring the data into a parent list. Thanks in advance.
