OK, so a Pipeline can do this.
But before we do that make sure that the Site has a summary field for the # of Buildings and look that up down to Site Costs. So The site cost in your example knows there are 5 Buildings. Create a new field called Building Allocation which will be the $50,000 / 5 = 10,000.
Trigger on New Event for the Site Costs table, but for now within that, only set trigger on record added.
Search for Building where the Related Site matches the Related Site of the Trigger record.
Then "For Each",
Create a building cost record being sure to attach it to the correct [related building] the result of the search step (probably {{b.id}}
and populating the field for the $10,000 Building Cost from the trigger record.
ā
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------