How to get an average from related field data

[EdwardC]

Still trying to master relationship set ups! I have a one to many relationship and I'm having a prob with something probably simple: I have an individuals table and another table with interview records where the person was weighed at each interview and each person had 3 interviews (so 3 weight records). Question: How do set up the relationship graph so that - other than viewing different weights from weight field from each record in a portal in the individuals table - I can use the average calculation to bring in the weight from each of the separate three interviews into that calculation? What I tried didn't work.

[bcooney]

Using your existing relationship from parent to child (your portal's relationship), just create a calc field in the parent:

average (parent_Child:weight).

btw: you may wish to adjust the skill level that you've listed for yourself.

Edited September 6, 2008 by Guest