kcrossley Posted May 25, 2001 Posted May 25, 2001 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
proton Posted May 25, 2001 Posted May 25, 2001 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now