How to sum records on a different table when fields match

[Joey_Seal]

Here is a sample

Airtable

Lookup Test - Airtable

Explore the "Lookup Test" base on Airtable.

I would like Jobs::Total to show a sum of the Hours::time when Jobs::Work Order matches Hours::Work Order. How can I do this without manually linking each hours record?

Thanks

[Gordon_Smith1]

I have the same question. Did you ever find an answer to this?
Gordon