I want to create a report where I reflect the details from Table 1 & Table 2. I have two tables that reflect the same data but with a slight variation. In the Table 1, the persons name appears as first name, and surname as individual fields. In Table 2, the same person will appear as the the first name and surname combined however limited to 29 or 30 characters. How would I match the data correctly or link it together so that the same person may exist as one record in a report.
Example:
Table 1
First name: Barry Roland James Porter Ta
Surname: Anastasia
Table 2:
Agent: Barry Roland James Porter Ta A
