AnsweredAssumed Answered

Moving a summary field from one table to a related table.

Question asked by gamccom11 on Mar 18, 2018
Latest reply on Mar 18, 2018 by gamccom11

I have a sales file with a field called Total Sales and a SUM Total Sales as a summary field.  I want to bring that summary field over to a related table called Dashboard.  The two files are related by Customer Number.  I have read a bit on how summary fields can or cannot perform in related fields.  Can anyone help me to get the Sum Total Sales to accurately reflect the total of all sales in all found records in the Sales table when placed in the Dashboard table?  The only relationship that exists is customer id = customer id in each table.

Outcomes