I need to create a very simple master calendar, but don't know how. I have two tables, [Systems] and [Platforms]. Systems table has years 2010-2025 in field SystemsYear, while Platforms table has years 2001-2025 in field PlatformYear.
I want to create a new table and field 'Year' for the period 2010-2025 as my master calendar. I do not care about data before 2010. What does the script look like for this?
Thank you both for your responses. Your methods actually generated a loop, I am not sure why. So I instead renamed both SystemsYear and PlatformYear to 'Year' first in the script, then edited your script slightly. So now the three tables are just linked by Year.