How do I pull the Total Qty from one table to another?
I have two tables. The first table has a field called Total Scrap. The second table has multiple values and are summed up. I can't get the total sum to pull over to the first table.
If there is a relationship between the tables where 1 Job has Many child records, then you can edit the relationship to create a summary field using the button on the left side of the relationship.