I'm building a database for my cabinetshop.

We fabricate in millimeters but communicate with the customer in inches.

We use the Extend function to convert inches to millimeters.

If you type in the value 36 inches it displays as 915 millimeters.

I would like this value to display in both inches & millimeters,

but I would like it to be done with just one field.

Is there a way to trick a repeating field into using one calculation for Repetition (1) and another calculation for Repetition (2)?

Thanks for any tips,

Jarvis

Simple example:

case(

Get(calculationRepetitionNumber) = 1; extend(someField);

Get(calculationRepetitionNumber) = 2; extend(someField)* 36

)

But repetitions frequently lead to a host of problems and in general should be avoided.

Thanks Bruce.

I will try that.

Jarvis