Store Form Data Into Table
I have a large database in which I have a small problem. Hereby attached that database for only the part thats interesting for this.
There are records in the table Exams_2009 which has a lot of numbers in them. On a specific form (also called Exames_2009) all these numbers are displayed and there are fields that sum specific columns and rows and display the total. Now the problem comes, they aren’t stored in the table but can only be seen on the form. The question is: how to sum the totals like is done now but also store them in the field of the record. There are over 50 of these sums in the form and the real database has over 10 of these forms…
I only need to have explained how to solve this issue, not the real database changes, Hopefully it can be done in an efficient way because it needs to be changed 10 forms x 50 times. Off course it would be nice if I get an example of how to change it in attached example database.
