Subtracted value from separate table data

[Corey-Troy]

I am trying to get the correct syntax to subtract a value in an existing Table 2, by a Table 1 field value.

I currently have

Set Field[Table2::Remaining Value;Table2::Remaining Value-Table1::Used Value]

However, the value that is subtracted when the script runs is actually a value in a previous record of Table1, instead of the required record in table1.

How can i stipulate the Record field value of Table1 to subtract from the Table2 field value?

I already am using a Copy/Paste above this step of the script as part of a find to select the correct Record in table2.

[Corey-Troy]

I Solved it somehow !

But i have another Question, but on a slightly different item so i will create a new Topic.

Edited May 27, 2010 by Guest