Remember that the field names must be fully qualified. This means that if you have a valid relationship to your second table called "table2", the actual calc would look like this:
Set Field By Name[ ("table2::" & field1 & field2); value ]
If that does not work, please post the error message that you are getting when you try it.
Yeaah !!! you've solved the first part of my problem thank you, it's works now but i got a second problem i want to add the result to the target field
for example : i have 5 in the target field if i "send" 4 as a value i want to have 9 in the "calculated" target. Is it possible ?
I have a third question is it possible to make the inverse process ? like this :
Table1 : Part1 Part2 Value
Table2 : VAR1 VAR2 VAR3 VAR4...
Is it possible to put in "Value" field the value of the target field make by the combination of Part1 and Part2 ?
Good question, this is really the answer to questions #2 and #3.
Use the GetField() function for this - you pass it the name of a field and it returns the value (you could also use Evaluate, but for simply getting the contents of a single field, GetField is simpler).
So the formula would look like:
GetField( "Table2::" & Part1 & Part2 )
Once you know how to do this, you have the answer to the other question about adding the values together, because you can get the value, add it to what you have in currently, and store the sum in Table 2.
IT WORKS !!!!
thank you very much it works as you said ! it's a miracle :smileyvery-happy:
'was bloked since a week ! (i've made an other solution but yours is better ;))
Once again thanks a lot