dwperry1 Posted February 22, 2012 Share Posted February 22, 2012 How do you establish a tax rate in a MySQL database to use in a form calculation, then be able to change the value to a new constant value from the form? Quote Link to comment Share on other sites More sharing options...
ManiacDan Posted February 22, 2012 Share Posted February 22, 2012 What, exactly, are you asking here? Databases have no concept of taxes, they're just numbers. You have to write the logic yourself. Quote Link to comment Share on other sites More sharing options...
dwperry1 Posted February 22, 2012 Author Share Posted February 22, 2012 You're right! A better question is: how do I establish a constant value in the db to be used in a form until the constant is changed by the user? Establish a constant value: Change that constant at some point (like when you have new tax rate): Quote Link to comment Share on other sites More sharing options...
ManiacDan Posted February 22, 2012 Share Posted February 22, 2012 Make a table. Put a number in the table. Make a form that will update the number when the user puts a new number in. Use the number from the table in your calculations. This is sort of the entire purpose of databases. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.