Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8573 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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.

This topic is 8573 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.