Calculated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got to add to each record in the table two additional fields whose values
are to be calculated on the base of the other fields from the same record
(it is sort of a scoring procedure for the data). The calculation procedure
is very complicated. The question is what is the best way of doing that? I
don't want my operators to click on a button created specially just to run
the scoring procedure. What I would like to do is to calculate the values of
these two fields as soon as operator completes data entry for a record via
interface form.
 
Jimmy Ionic said:
I got to add to each record in the table two additional fields whose values
are to be calculated on the base of the other fields from the same record
(it is sort of a scoring procedure for the data). The calculation
procedure
is very complicated. The question is what is the best way of doing that?
I
don't want my operators to click on a button created specially just to run
the scoring procedure. What I would like to do is to calculate the values
of
these two fields as soon as operator completes data entry for a record via
interface form.
Click to expand...

Why store them in the table? Create two calculated fields on the input form
and on any report that needs them.

Tom Lake
 
Back
Top