form calculation not showing in table

[dosima]

Hi

i have a table with loan amount and charges which add up to create a balance
which is also a field in the table.
i have created the form for this table and created the calculation for the
balance field to add up the loan amount and charges.

The calculation on the form adds up correctly, the problem is that i dont
understand why the balance data is not going into the balance table. the loan
amount and charges inputted on the form is being entered onto the table, yet
the balance is not.
Can someone tell me what i am doing wrong, or if i should be doing it a
different way.

thanks in advance

 

[Klatuu]

The only thing you are doing wrong is trying to store a calculated value in a
table. Doing so violates database normalisaton rules.
It wastes disk space, it takes time, and is very likely to become incorrect.
Just show the calculation in forms and reports where a user needs to see the
information.

 

[Stockwell43]

The balance is not suppose to go in the table. The rule of thumb is not to
store calculated fields. But, in answer to your question:

Do you have the field related to the table? So whatever your balance field
is called, is it also on the table? If not, that's why it doesn't appear. You
should be using an Unbound text box for your calculation on the form and have
it total on the report.

Hope this helps!

 

[dosima]

Hi

i've created the a text field and shown the balance in there, and have also
made the balance show up in a report.

thanks for your help.