Your system of linked records looks fine. There could be some tweaks that uses automations for creating the links when there is a new week or quarter. The exact automation would depend on your workflow for creating weeks and quarter records.
Thank you, kuovonne! I manually input the week ending date from Table 1 which then generates the Quarter and Year via formula. Does that give you any more information to make this process more automated?
If you don’t have an automation for it already, you could use an automation to create the link to the quarter record. You may need to be careful with the trigger for the automation to ensure that you are done typing the end date and the formula for the quarter has time to calculate.