Skip to main content
Question

Year by year Matrix for company info

  • July 31, 2019
  • 0 replies
  • 12 views
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?

      This topic has been closed for replies.

      • XavierFan
      • Registered
      • August 1, 2019
      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.
      Terms & ConditionsAccessibility statement