How can I show in the list form and in the edit form, a value that should be calculated from values from 5 tables.
I want to show in the list form and in the edit form of a table (lets say the main table) a value that uses a field value from ther 5 tables (all related with the main table) to make the calc.
All that 5 tables includes a field named ACTUAL_STATE (int). I show it as radiobuttons (20%(20);40%(40);60%(60);80%(80);100%(100)). Now, I want to show in the main table the global state. I want to sum the field value on each table and in the end divide it by 5 ((n1+n1+n3+n4+n5)/5) and show than value in the list and edit form.
How can I do that?
Thank you.