How do I share date between multiple tables? ...

[vicodu_Odu]

How do I share date between multiple tables? I want the parent table to aggregate the data from the child table

[Aleksi_Alkio]

You can do that for example with a formula… SUM(SELECT([RelatedChildRecords][ValueColumn],TRUE))

[MultiTech]

SUM([RelatedeChildeRecords][ValueColumn])

should work too

[RezaRaoofi]

Aleksi’s above formula (with SELECT) was the only way it worked and introduced when filtering Ref lists was originally released a year ago; COUNT() worked without SELECT though, but it was necessary in SUM() function; sounds like it has been improved and now SUM() works without SELECT too.

Here is the original post for a trip down memory lane! https://plus.google.com/116466377064499551355/posts/2pYP8FvUucn

[vicodu_Odu]

Thanks Aleski, it worked like a charm

[Aleksi_Alkio]

You’re welcome