Re: Historical Project Status
I think you should go up, rather than down.
What I mean is you should make a "Months" table, and have that be the parent to the projects.
Then You'd just need to make the Month Records (Jan 2017, Feb 2017, etc.) and the relationship can be set up to be automatic based on the key dates you have.
No need to make a million child records.
Let me know if you'd like more guidance on setting this up.
What I mean is you should make a "Months" table, and have that be the parent to the projects.
Then You'd just need to make the Month Records (Jan 2017, Feb 2017, etc.) and the relationship can be set up to be automatic based on the key dates you have.
No need to make a million child records.
Let me know if you'd like more guidance on setting this up.
