Table within a table

[clutter]

I am trying to set up a data base to keep track of lesson plans and generate assignment sheets. I have a list of courses, within each course there is a list of weekly topics (a variable number of weeks not more than 36) and within each week there are 4 daily assignments. I have tried without much luck to figure out if I can do some sort of nesting with tables. I would like to be able to have a list of courses, click on one and have it open to a list of weeks for that course and click on a week to open to a list of days for that week. Can anyone help?

 

Susan

[David Head]

Hi Susan

What you need is a relational structure between your tables. Your entities (tables) are Course, Topic and Assignment. Each of these tables will have a unique ID for the relevant records. You would set up relationships between table occurrences:

Course ---

 

I don't have time right now to set up an example but it is pretty straightforward realtional structure.