2 Replies Latest reply on Dec 25, 2014 10:03 AM by philmodjunk

    How to Display Total payments from a field that contains a list

    jakes

      Title

      How to Display Total payments from a field that contains a list

      Post

      I have a field that contains a list of payment numbers:

      For example:

      Table 1, Field 1:

      P00001

      P00010

      P00022

      Table 2, has all payment details

      id, date, amount

      I would like to display the total amount from table 2 in table 1, however the related id numbers are saved as a list in field 1 in table 1.

      How can I accomplish this?