How to Display Total payments from a field that contains a list
I have a field that contains a list of payment numbers:
Table 1, Field 1:
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?