2 Replies Latest reply: May 15, 2017 1:33 PM by Jacob Salas RSS

    %Key field link tables

    Jacob Salas

      I am trying to connect two tables and the data is not a one to one connection.


      Table one is structured as so:

      Job#QuoteQuote Cost
      12345, 12346500$10,000


      Table Two is structured as:

      Job#Actual HoursActual Cost



      Is there a way to make The Jobs 12345 and 12346 with the , separator link to two different lines so I can pull the Quote values to compare?


      Thank you.