create a field that averages data based on a shared ID in another field
I have a table that will ultimately contain entries with a measured value in a field and I need to be able to display a mean for entries that share the same ID number. Basically I want a field that will find the entries with a matching ID (matches the entry in the parent table) and then displays the average for that field. Is this possible? How?