new custom record field for a record type - not getting refreshed fast enough

Hi All,

I have created a new custom record field for a record type - this new record field depends on a relationship with another table .

So when I'm writing to the child table(relationship table) how long does it take the main table with the new custom record field to get updated?

I'm asking this because first I write to the child table then I want to write to the main table using this new custom record field for a calculation. The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working.

Any recommendations here?