PROBLEM
In our TABLE 1 (PROJECTS):
We want our concatenated field to read: P1234 (Joe Smith - Smith, Joseph & Jones)
What we get: P1234 (“Joe Smith - Smith, Joseph & Jones”)
Where: Joe Smith - Smith, Joseph & Jones is a linked field to our TABLE 2...