|
||||||
|
System Defaults By Richard Rost ![]() ![]() System Defaults Table for Default Values in Access In this video, I'm going to show you how to create a System Defaults table that you can use to provide default values for fields in your database that may change from time to time. This way you don't have to make design changes to your tables. Santos from Casa Grande, Arizona (a Platinum Member) asks: I have to change the default values for some of our fields on a regular basis. For example, we have different loan rates that change from time to time. When we go to enter loans, we have to keep constantly looking up the rates. I've been manually going into the table and changing the default value, but that's annoying to constantly make design changes. Is there a way we could just store this value in a table and look it up? And this is just one value. I've got a bunch of them I need to change regularly. MembersMembers will learn how to make a custom function to supply a default value for something that's not as simple as a lookup, for example giving a default discount rate for customers based on how many years they've been a client.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today! Discount For ItemsYou can also calculate a discount percentage for each line item as well. Perhaps services are 50% off but products only 20%. This is a little more complex, and I cover it in Access Expert 9. Links
Keywordsmicrosoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, default value from record, default value based on another field, default value from table, system settings, system values, system defaults, default settings table
|
||||||||||||||||
| |||
Keywords: TechHelp Access default value from record, default value based on another field, default value from table, system settings, system values, system defaults, default settings table PermaLink System Defaults in Microsoft Access |