Display Total from 1 table in another

I’ve searched this topic but I’m obviously missing something because it seems too simple …

I have a table of parts, each of the parts have a cost so the table has a Total column.

I want to have that Total value appear in another table (then I’ll be deducting that value from corresponding columns to generate another figure.

How do I simply reflect the value from a column in 1 table, in another table?

Like I said, it seems crazy simple…

Hi @Herbshirt

You have to link every record from the {Parts} table to a single record (a summary record) in your other table where you want the Total to show up. Then, in the {Totals} table you’ll need to use a Rollup function to get the total from all the linked {Parts} records.

It looks something like this:

When you say 'link every record" - what if I have a hundred rows??

You can copy the value from one and paste in the others (select full column clicking the header and paste).