Calculation question for two fields

[mcyrulik]

OK ladies and gentlemen,

The attached picture is out of an estimating program I built. As it stands, the markup field is edited by the user, which then calculates the unit price and the total price. Works great....

Now my user wants to have the flexibility to update either the markup or the unit price and have the other update accordingly.

If I put auto enter calcs on both fields, and I update the markup, the unit price updates, but then because the unit price updated, the markup updates again.

Is there a way that I can stop the field that was just edited from updating, but still have the other one update correctly?

[comment]

See if this helps:

http://www.fmforums.com/forum/showpost.php?post/165927/

[mcyrulik]

That worked perfetly!

Thanks a Million comment!

[mcyrulik]

I got the desired result - sort of.

the one problem I ran into is that using this method, the unit price does not update when the unit cost changes - just when the markup changes.

The unit cost field is a calculation of total_cost/qty.

I have tried using total_cost/qty in place of unit price in the else protion of the if, but that doesn't seem to work.

Any ideas on ways around this?