13 , . . , , , . , . . . 14.19 14.20 Cacophone Studios.
, . 14.19 14.20, . See Students in this Class.
, , , .
1. .
Classes.
2. . .
.
3.
.
.
. 14.19. Classes . See Students in this Class ( ) (. 14.20)
. 14.20. StudentEnrollments ( )
4. , ,
.
StudentEnroIlments.
5.
.
StudentEnrollments? , . , , , . , .
6. - .
, , (.. " " 13).
7. .
, , . , .
, Access. . .
8. , | → → (Form Design Tools | Design → Tools → Property Sheet).
|
|
9. , .
.
10. (OnClick).
[ ], , .
11. .
, , . 15. .
12. . ( .) , (. 14.21).
, , , .
13. ( , ) .
. , , .
:
[ClassID]=[Forms]![Classes]![ID]
. 14.21.
Access , , ClassID StudentEnrollments ID Classes. , , .
. , ( StudentEnrollments) ClassID. ID, (Classes). [Forms]! [Classes]! [ID] Access , ID Classes.
14. , , , . , , (Requery) (. 14.22).
Access ( StudentEnrollments, ). , StudentEnrollments , See Students in this Class. , , . .
. 14.22. .
15. . Access .
, , . .
|
|
. See Students in this Class StudentEnrollments, .
→ ( (Filtered), , ). , StudentEnroIIments , . , .