4 Replies Latest reply on Nov 3, 2016 5:41 AM by james.carrington

    How can I join two tables when one field is a calculated field?

    james.carrington

      In table one I have a field called [name], e.g. John Smith

      In table two I have a field called [first name] e.g. John, and a field called [last name], e.g. Smith

      In table two I have created a calculated field called [client name] which concatenates the above two fields.

       

      how can I join these two tables based on the [name] and [client name] fields? Is this even possible? Or is there another way?

       

      Thank you in advance,

      J