Having a modifiable Calculation field

[SteveGriff]

Hi people

I have a small problem concerning calculation fields.

I have this calc field, Unit Price that calculates by how many the customer is ordering from us. (case(Quantity > 50 and Quantity < 50; 3.00; 4.00) etc. )

The problem occurs when someone wants to put in their own Unit Price regardless of what the calculation result of the Unit Price should be.

Anyone know how I might get around such problem?

Any nice tips on doing such a thing?

Thanxs

Steve Griff

[SteveGriff]

One quick question to make sure I get this right. This involves having another field visible for entry yeah?

Is this the case of "one field above the other" trick? I can see how the Case works for this...

I guess this would work?

Steve

[signal]

Create another field for overriding the calculation.

Then,

if (isempty(FieldForOverride) do the calculation, otherwise use FieldForOverride

[Fitch]

Been there, done that...

Make another field, Override, and then change your Case() statement so that the first test is:

Case(Override, Override, ...now put your old tests...)

[Fitch]

signal, you're too quick for me!