AnsweredAssumed Answered

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

Question asked by jakes on Dec 25, 2014
Latest reply on Dec 25, 2014 by philmodjunk

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?

 

Outcomes