HELP: Update 1 table with calculated fields from another table

S

Samora

Hell

I have a form who have 10 fields from TABLE1 that after make calculations with them
i build the field M1 from TABLE

The event that fires those calculations is AFTER UPDATE field D1 from Table TPavimentos in Form FrmCalcul

How can i update the TABLE2 - field M1 ?

the tables are
TPavimentos
TMomento

Form FrmCalcul

Table to be updated TMomento
Field to be update M

the field M1 has to be calculated a several times
on position 0 and position 250
For position = 76 to 17
Click to expand...

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 HAV
ANY FIELD that can make a relation between TPavimentos and TMomento

Important: I dont want to store these values in table TPavimentos but only in table TMomento

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 YO

Best regard
Samor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

From one table -> update the fields from other table 1
Seriously, I need ideas. Fields not transferring from table to table 5
Update Query returning zero for a calculated 'update to' 1
Update the values in a table from another table 1
Setting field value if a value exists in another table 0
Update a field from 1 through 10 6
does a querry update a table 7
Update Value in Table based on to that of Another Field 2

Top