I want to format a price field, such that when a Customer Type field has radio button "Dealer" clicked, the price will be $X, but when "Non-dealer" is selected, the price will be $Y. The button needs to be "live," not an auto-enter at record creation based on a selection that hasn't been made yet. But the price must be overideable by the user. How can I do this?

Make the Price field two fields:

Price Entry (number)

Price Display (calculation, number) =

Case(

NotIsEmpty(Price Entry), Price Entry,

Customer Type = "Dealer", $X,

$Y)

Put the Price Display field on top of the Price Entry field. Make the Price Display field opaque and disallow entry into it (I know you can't really change it, but do it anyway!). When you click on the Price Display field, you will land in the Price Entry field beneath it.

-bd