This content has been marked as final. Show 5 replies
Okay. You speak of an historical data table and a data entry form. Are you filling the form and then writing the record(s) to the table? Are these all inserts to the table. Any updates to or deletes from the table?
Or, do you just need the calculated value to display on the form and nothing is written back to the table?
Thanks for the reply. Yes, I want to write the record back to the table. And yes, I may also be doing updates and deletes of records as well. I wanted the calculated field to be written to the table in the field columnC that will hold the result of the calculation on the form (which result from columnA/columnB).
Thanks for any advice,
I guess it depends when/whether you want the field recalculated.
How about a dynamic action (DA) that recalculates that field whenever you load that form and another one (or two) for whenever you change either of the values it depends on?
Can you give me some idea how I would go about doing that with dynamic actions?