FStudentGradeView: Hints on this one: Begin just like you did for Use the Subform/Subreport tool. When you build the FStudentInfo. subform in the wizard, choose and instead of an existing even if “Use existing Tables Queries” “Use Form”, you’ve already created (which contains exactly the information you need.) This is because FGrades is set up to FGrades use Form View. To use Datasheet View (as shown have to change the default format. Better to above), you’d simply have a second form named that has the datasheet view as the default. Do you see the FGradesSubform – – role that a foreign key is playing? Note: You can change the caption (title) of a form and many other properties by right-clicking on the title bar in – – Design View and choosing the option. Spend some time exploring this feature. Properties
FStudentGradeView: Hints on this one: Begin just like you did for FStudentInfo. Use the Subform/Subreport tool. When you build the subform in the wizard, choose “Use existing Tables and Queries” instead of “Use an existing Form”, even if you’ve already created FGrades (which contains exactly the information you need.) This is because FGrades is set up to use Form View. To use Datasheet View (as shown above), you’d have to change the default format. Better to simply have a second form – named FGradesSubform – that has the datasheet view as the default. Do you see the role that a foreign key is playing? Note: You can change the caption (title) of a form – and many other properties – by right-clicking on the title bar in Design View and choosing the Properties option. Spend some time exploring this feature.