Cont Form and Row Total

  • Thread starter Thread starter Bryan Hughes
  • Start date Start date
B

Bryan Hughes

Hello,

I have a continuous form that has 5 fields the user inputs numbers in the
first 4 fields, then the total of the fields for that record goes into the 5
field.

How do I get the total for those fields for a single row to auto update the
total field for that row after user updates a row?

-TFTH
Bryan
 
Bryan said:
I have a continuous form that has 5 fields the user inputs numbers in the
first 4 fields, then the total of the fields for that record goes into the 5
field.

How do I get the total for those fields for a single row to auto update the
total field for that row after user updates a row?
Click to expand...


That would be a relational database normalization rules
violation. You should not save values that are calculated
from other values, especially from values in the same
record. Just perform the same calculation whenever you need
to display the total to users.
 
Back
Top