Discussions

 View Only
  • 1.  Year by year Matrix for company info

    Posted 07-30-2019 21:04
    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?



  • 2.  RE: Year by year Matrix for company info

    Posted 08-01-2019 11:32
    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.