I'm struggling to find the solution to this problem and I think part of the reason is finding the right wording to explain my problem so I'll try my best to explain what the problem is.
I have a SharePoint list (List A) and on this List A I have a lookup column which looks up 'School Name' from List B. When creating the ...