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
      12347300$7,000

       

      Table Two is structured as:

      Job#Actual HoursActual Cost
      12345550$11,000
      12346520$10,500
      12347200$6,000

       

       

      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.