Calculating Field Values from multiple attribute tables

Discussion created by rralbritton1981 on Mar 25, 2013
Latest reply on Mar 27, 2013 by gprince-esristaff
I have an attribute table (let's call it table X) that I need to calculate field values for.
I have five additional attribute tables (lets call these tables A,B,C,D,E) that contain field 1. For each record in each table (A,B,C,D,E) I need to get an average for these five records and have that average recorded its corresponding field in table X.

For example looking at record ID1 in all tables, A=1 B=2 C=1 D=3 E=5
The value for record 1 in table X would = 2.4 ((1+2+1+3+5)/5))

The calculate field tool appears to only let you calculate a field value based on other fields in the same table. I need to calculate fields based on fields in other tables. Can I do this?