And what would the completed schedule look like?
Here is a copy the most recent one I have done. It was completed using a table MS Word.
What you show looks like something that you can set up with 5 portals, one for each day of the week. The portals would show data from a related table where one record represents one block of time on a specific date or day of the week.
One possible set of relationships for that:
Weeks::FirstDayOfWeek = TimeBlocks::FirstDayOfWeek
Courses::__pkCourseID = TimeBlocks::_fkCourseID
The portals can include a portal filter that filters for a specific day of the week.
But you'll need to input more data than:
I have a table with the courses already populated and a [Duration] field with the number of hours inputed for the length of each course.
You'll need to set up a method for assigning a specific section of your schedule to a specific course. There are multiple methods for doing that. One approach would be to format the _fkCourseID field in the portal for selecting the course for that TImeBlock record.
While not set up exactly the same way, you may see some ideas that you can use in this Calendar demo file: https://www.dropbox.com/s/e8d03xvwe8vtz85/Calendar.fp7
Okay Phil, I have some work ahead of me but thank you so much again. I will play around with it.