View Single Post
  #1  
Old May 23rd, 2004, 05:16 PM
Samora
external usenet poster
 
Posts: n/a
Default 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