I am using SharePoint 2013 (on-premises) and InfoPath 2013 to customise a list form.
First I need to explain the configuration of my various SharePoint lists that I'm using for lookups.
On my parent site I have a list called "Teams" (a custom list with 1 column entitled "Title" which is single text). ...