Microsoft Access 2D: Using a Subdatasheet, Insert Subdatasheet from Another Table

Relational Subdatasheet:

You have seen one of the features of a relational database in the last assignment where instead of keying in the names of students in a table such as tblTimetable, you simply created a lookup list that retrieves the data from tblStudents.

In general terms relational means the ability to look up information from another table.

Another feature of a relational database is the ability to use a subdatasheet.

When you open the form for a student in your database now, unfortunately there is no information other than address, student number etc.

It would be useful to have a list of all the students' classes on the form as well.

At this point however, you must use tblTimetable to find a student's classes, and then you must know the student's student number to find the classes.

A subdatasheet will allow you to see all the classes for a particular student on the form with the rest of the student information.

The form will lookup the student number in tblTimetable and display the classes on the form as shown below.

In future assignments you will learn how to create a subdatasheet for a student's attendance (the subdatasheet will show the day's they have attended or not attended and a reason for not attending)

Another subdatasheet covered in future assignments will be created to show the textbooks that a student has signed out in the school.

Other subdatasheets could include grades, fees owed etc.

This website is copyright protected see contact page for details.