Can't devote much time to this at this hour but to quote you
I think I need:
Table 1: Date, Item Name, 7a, 11a, 3p
Table 2: List of Items, Custom Sort Order for items, Type of Item
definitely NOT. That is an Excel influenced design. You need to review and understand relational database design. Perhaps
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html
I suspect you should review other db design concepts but I don't want to presume too much at the moment.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.