HELP: Update 1 table with calculated fields from another table
Hello
I have a form who have 10 fields from TABLE1 that after make calculations with them
i build the field M1 from TABLE2
The event that fires those calculations is AFTER UPDATE field D1 from Table TPavimentos in Form FrmCalculo
How can i update the TABLE2 - field M1 ??
the tables a
TPavimentos
TMomentos
Form FrmCalculo
Table to be updated TMomentos
Field to be update M1
the field M1 has to be calculated a several times:
on position 0 and position 250
For position = 76 to 174
for both situations the formula is the same.
the table is an intermediate table from where i have to get some values for the next calculations and i DONT HAVE
ANY FIELD that can make a relation between TPavimentos and TMomentos
Important: I dont want to store these values in table TPavimentos but only in table TMomentos
PLEASE : DON'T LOOK TO MY POST NAMED "FROM ONE TABLE UPDATE THE FIELDS FROM OTHER TABLE" .
IT'S THE SAME THING, BUT THE EXPLANATION OF THE PROBLEM WAS UNCOMPLETE.
THANK YOU
Best regards
Samora
|