I'm designing a database with a pulldown text field (Select Postage Type) that is linked to a calculated field (Postage Rate). The pull-down field allows the user to choose from several different postage options for catalog mailings. The choices are:

Standard Postage A

Standard Postage B

Custom

When either Standard Postage options are selected in the (Seloect Postage Type) field the (Postage Rate) field automatically enters a numeric value using a Case statement. However, when Custom is selected I want the user to be able to modify the (Postage Rate) field which you can't because calculated fields are not modifiable.

How can I make this work?

Thanks for your help.

- Kelly

quote:

---

Originally posted by kcrossley:

I'm designing a database with a pulldown text field (Select Postage Type) that is linked to a calculated field (Postage Rate). The pull-down field allows the user to choose from several different postage options for catalog mailings. The choices are:

Standard Postage A

Standard Postage B

Custom

When either Standard Postage options are selected in the (Seloect Postage Type) field the (Postage Rate) field automatically enters a numeric value using a Case statement. However, when Custom is selected I want the user to be able to modify the (Postage Rate) field which you can't because calculated fields are not modifiable.

How can I make this work?

Thanks for your help.

- Kelly

---

Well kcrossley,

I'm sure that there may be a number of easy ways to do this, but I'll just suggest what I normally do in these circumstances. I would create a field called say "Custom Postage Rate" which would be a number field.

If the user selects Custom, then they would go to this field and enter the custom rate. Then I would modify the calculation field to so that if Custom is chosen, then it would take the value from the newly created Custom Postage Rate field. Hope this helps.