Mass adding of templated rows and working with dates via columns:
I have a project for the local “meals on wheels” for the elderly.
There are around 60 people who have meals delivered daily.
Every month needs to be replicated, and then changes made to that months planning.
Weekends need to be identified within the month reporting.
My first thought was to set up a table with [Name], [Date], Order.
However replication of that for an entire month for 60 people is 1,800 rows and I don’t know if this is possible.
My second thought was to have a table with columns [Name], [Month], , ,  etc…
Where each column represents a day of the week of the stated month.
a y/n in each day column would reflect an order for that day.
Now I only have to replicate 60 rows each month.
Does anyone have any opinions for me to get started?
Option1 lends itself to easy calculation of weekends - It must be possible in option2 but with more work?
I’m assuming for every option2 record I could create virtual columns that would return a day of the week for every date calculated from the month plus column header (max 31 virtual columns) and somehow correlate (tag) the appropriate virtual column to the main column.
And ultimately can records be auto created as intended?
If the answer is yes I’m sure I can work it out, but if not I’ve saved myself time by asking the question.