event procedure

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

Guest

Hi all,
I am trying to perform an afterupdate procedure. The information needed
comes from a couple of different locations. They are tables;
Lopez flow table, the field needed in this table is [term res to plant].
lopez chemical feed table, the field here is [coag aid lbs fed].
The form I am using is based on the lopez chemical feed table. The field I
need populated from the afterupdate is [coag aid feed ppm] on the lopez
chemical feed table. so the equation needed is:

[coag aid ppm] = [coag aid lbs fed] / [term res to plant] * 8.34.

thanks for any help you can provide.
 
Not sure I understand what you want to do.

Typically, you would not store a calcaulated value in a table, you'd
calcualte it when you need it using the data you have in the table.

[coag aid ppm] should not be stored, but calculated on the fly.

If you store it, what happens if one of the three variables that makes it up
changes later? What will prompt the field to be updated?
 
This is typically a one time calculation. I would want to use the data to
generate a report at a later date.
I want the information available to operations staff. Operations staff are
not completely database literate.

Is there a way to perform the calculation as I asked?

Rick B said:
Not sure I understand what you want to do.

Typically, you would not store a calcaulated value in a table, you'd
calcualte it when you need it using the data you have in the table.

[coag aid ppm] should not be stored, but calculated on the fly.

If you store it, what happens if one of the three variables that makes it up
changes later? What will prompt the field to be updated?



--
Rick B



ckesler said:
Hi all,
I am trying to perform an afterupdate procedure. The information needed
comes from a couple of different locations. They are tables;
Lopez flow table, the field needed in this table is [term res to plant].
lopez chemical feed table, the field here is [coag aid lbs fed].
The form I am using is based on the lopez chemical feed table. The field I
need populated from the afterupdate is [coag aid feed ppm] on the lopez
chemical feed table. so the equation needed is:

[coag aid ppm] = [coag aid lbs fed] / [term res to plant] * 8.34.

thanks for any help you can provide.
Click to expand...
Click to expand...
 
When you want to provide the number in a report, add an unbound control and
create it.


--
Rick B



ckesler said:
This is typically a one time calculation. I would want to use the data to
generate a report at a later date.
I want the information available to operations staff. Operations staff are
not completely database literate.

Is there a way to perform the calculation as I asked?

Rick B said:
Not sure I understand what you want to do.

Typically, you would not store a calcaulated value in a table, you'd
calcualte it when you need it using the data you have in the table.

[coag aid ppm] should not be stored, but calculated on the fly.

If you store it, what happens if one of the three variables that makes it up
changes later? What will prompt the field to be updated?



--
Rick B



ckesler said:
Hi all,
I am trying to perform an afterupdate procedure. The information needed
comes from a couple of different locations. They are tables;
Lopez flow table, the field needed in this table is [term res to plant].
lopez chemical feed table, the field here is [coag aid lbs fed].
The form I am using is based on the lopez chemical feed table. The field I
need populated from the afterupdate is [coag aid feed ppm] on the lopez
chemical feed table. so the equation needed is:

[coag aid ppm] = [coag aid lbs fed] / [term res to plant] * 8.34.

thanks for any help you can provide.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top