Cont Form and Row Total

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
 
M

Marshall Barton

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?


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top