I need to map one of the location field to a separate table.
My issue is in SharePoint you can select multiple locations, they are pulled across as 1 long string.
Record 1: Site 1#; Site 2#; Site 3
Record 2: Site 1
Record 3: Site 2#; Site 3
I'm imaging a mapping table with the condition, if the field from SharePoint contains the field in the Location Table then link the two, but I have no idea what this might look like. Any help appreciated