Year by year Matrix for company info
I want to relate the data on this Matrix into records for each company and I want to save (create) the data each year. What is the best way to create this without having 14x3 fields?
Forum Discussion
You can consider using a child table for this.
Parent Table = Companies
Child Table = Yearly Data (or whatever you want to name this)
Relationship: 1 Company has many Yearly Data
So the data fields would be in the Yearly Data table.
You would also have a [Year] field in the Yearly Data table.
Each year, for each Company, you would add a Yearly Data record, with the data.
You'll end up with multiple Yearly Data records for each Company.
What you probably don't want to do is to create multiple fields for each year on the Companies table - that will greatly increase the number of fields on the Companies table, and isn't very scalable.
Parent Table = Companies
Child Table = Yearly Data (or whatever you want to name this)
Relationship: 1 Company has many Yearly Data
So the data fields would be in the Yearly Data table.
You would also have a [Year] field in the Yearly Data table.
Each year, for each Company, you would add a Yearly Data record, with the data.
You'll end up with multiple Yearly Data records for each Company.
What you probably don't want to do is to create multiple fields for each year on the Companies table - that will greatly increase the number of fields on the Companies table, and isn't very scalable.