Newbies Andrew Rose Posted September 9, 2020 Newbies Posted September 9, 2020 I have some data I need to store that closely resembles preferences. It's not going to change often and I'll want to refer to those values when calculating things in other tables. Like a tax rate container that I might refer to in a calculated field on item price. Were would I store those?
Fitch Posted September 9, 2020 Posted September 9, 2020 It's common practice to create a Preferences table that stores a single record. You can work with that data in various ways - through a relationship, via SQL, via script, or load the data into global fields or variables at startup.
Recommended Posts
This topic is 1603 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