Forum Discussion
Primary and Secondary tables, need help with relationship for auto create/update
Hi everyone! I'm getting into the weeds with a database i'm trying to update and could really use your help. Due to storage limits in the tables, i need to split the data and uploads into two tables....
Thanks, I'll take a look at those threads and see what i can do! It's definitely a spreadsheet style table, mostly to have an easy data export to excel. There's simply too many values/columns for a single table, so that's why I was looking into a secondary extension.
Thanks again!
-Ray
Thanks again!
-Ray
Ray_Barrit While it is true that tables in a normalized relational database application tend to have fewer columns in each table, that is a RESULT of the normalization process; it is not the goal in itself.
"There's simply too many values/columns for a single table" In other words, we have a principled process to reduce that number of columns. That process, called "normalization", is based on understanding RELATIONSHIPS between entities. When you do it that way, the natural outcome will be more tables with fewer fields. But, to repeat myself a bit, that's NOT the goal in and of itself.