Quick conversion calculation

[stanleypane]

I'm stuck on a rather simple problem and I am hoping one of the pros on this forum can help me out. Keep in mind that I am just beginning to get used to Filemaker, having never used it before.

I am setting up a database that will be used by some folks here is the U.S. and some folks over in China. In this database, we will include various measurements of sorts. Basically, we want to have the metric system and the standard U.S. measurements.

We have two fields in our database. Cent and Inch. Basically, when someone enters centimeters in the Cent field, we want the Inch field to calculate a division by 2.54. Vice versa for the Inch field. When someone enters a value in the Inch field we want the Cent field to do a multiplication by 2.54.

I can't for the life of me (remember, I'm a beginner) figure out where to start with this one. I thought it would be as simple as specifying a calculation for each field when I define my database. No dice. One field always takes precedence over the other.

Perhaps someone here would be so kind as to help me with this one?

[-Queue-]

Make Cent a number with an auto-enter calculation, and 'do not replace existing value' deselected, of

If( Get(ActiveFieldName) = "Inch"; 2.54 * Inch; Cent )

Similarly, make Inch an auto-enter calc, with 'do not replace existing value' deselected, of

If( Get(ActiveFieldName) = "Cent"; Cent / 2.54; Inch )

[Inky Phil]

I know this is not my post but thanks for that answer queue

Phil

[stanleypane]

Your response worked like a charm! Thanks for the help, -Queue-.