I need some help on a calculation where the original quantity and the balance fields reside on my master database and the inside quantity and the outside quantity fields reside on two different related databases.

I am trying " balance = original Q -( inside Q + outside Q )"

I cant get it to work correctly ( grrrrr !)

Any suggestions ?

Thanks

Hi Nick,

Since you do not say exactly what is not working and assuming that the basis for your calc is essentially correct then check the following.

If Balance is a calc field then the calc should just be '[color:blue]original Q -( inside Q + outside Q )'

You will probably want to check the 'do not store, calc as necessary option.

If you are using a script to set balance then the script step will be

[color:blue]Set Field[balance;Q -( inside Q + outside Q]

IN both instances make sure that when you select inside Q and outside Q that you select them to work via the

relationship[color:red]s which you change at the top of the field selection window.

I am afraid that these suggestions are a bit of a stab in the dark cos you didn't give us a lot to go on

hth

Phil

Edited April 21, 200817 yr by Guest

Thank you, you gave me the answer, the calculation was stored.

It works fine now.

Nick