Looking for the best way to do this. I’ve got a Unit table that stores all the details for a course Unit (e.g. Introduction to French):
I want to specify records for each week of that Unit, e.g. for the Unit “Musicianship 101”, we have a record for Week 1, Week 2, Week 3, etc (tracking information for each week):
I created a table Unit Weeks that looks like this:
Where the “Unit” field is a linked record back to the corresponding unit record in *Unit table.
What’s the neatest way to do this?
Solved! Go to Solution.