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.