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

(vicodu Odu) #1

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

(Aleksi Alkio) #2

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

(Multi Tech Visions) #3

SUM([RelatedeChildeRecords][ValueColumn])

should work too

(Reza Raoofi) #4

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! :slight_smile: https://plus.google.com/116466377064499551355/posts/2pYP8FvUucn

(vicodu Odu) #5

Thanks Aleski, it worked like a charm

(Aleksi Alkio) #6

You’re welcome