A
Ann
Is it kosher in these community groups to offer to pay
someone to set up a form and report (I have a Thursday
morning deadline in DC)? If not, I apologize for asking.
I incorporated Steve Schapel's suggestions (pasted in
below) creating additional tables in my student database
for class meetings and student attendance. I've spent all
day trying to create a form and report to be able to
update and print out attendance reports, to no avail. I
believe the relationships are accurate, but I'm unable to
set up a basic grid, with one class per page.
I have the following tables (relationships)
1. CLASSES (1>many w/3. 1>many w/4.)
2. STUDENTS (1>many w/3. 1>many w/5.)
3. CLASSES AND STUDENTS
4. CLASS SESSIONS (1>many w/5.)
5. ATTENDANCE
I would like a form that I could update every week
and a report that I could print out weekly
that read something like this:
Class Name: BALLET III
Sessions
Students Sep-13 Sep-20 Sep-27 Oct-8 Oct-25
Sally Smith P P A P
Julie Jones A P X P
Martha Mason P P P P
Is this really that complicated?
Thank you. (e-mail address removed)
Subject: Re: more student database questions
From: "Steve Schapel" <[email protected]> Sent:
10/7/2003 2:16:16 PM
Ann,
Congratulations on getting as far as you have. However,
it is a
mistake to put the meeting dates in separate fields. In
fact, in a
database it is always a mistake, where there is a one-to-
many
relationship between two entities, to define the data as
separate
fields. In this case, you have a one-to-many relationship
between
Classes and Meetings, and this means another table is
needed. For
example...
Table: ClassMeetings
ClassMeetingID
ClassID
MeetingDate
Then, as regards the Attendance, there is a one-to-many
relationship
between Students and sessions attended. Sooooo.... you
need another
table! For example...
Table: Attendance
AttendanceID
ClassMeetingID
StudentID
- Steve Schapel, Microsoft Access MVP
someone to set up a form and report (I have a Thursday
morning deadline in DC)? If not, I apologize for asking.
I incorporated Steve Schapel's suggestions (pasted in
below) creating additional tables in my student database
for class meetings and student attendance. I've spent all
day trying to create a form and report to be able to
update and print out attendance reports, to no avail. I
believe the relationships are accurate, but I'm unable to
set up a basic grid, with one class per page.
I have the following tables (relationships)
1. CLASSES (1>many w/3. 1>many w/4.)
2. STUDENTS (1>many w/3. 1>many w/5.)
3. CLASSES AND STUDENTS
4. CLASS SESSIONS (1>many w/5.)
5. ATTENDANCE
I would like a form that I could update every week
and a report that I could print out weekly
that read something like this:
Class Name: BALLET III
Sessions
Students Sep-13 Sep-20 Sep-27 Oct-8 Oct-25
Sally Smith P P A P
Julie Jones A P X P
Martha Mason P P P P
Is this really that complicated?
Thank you. (e-mail address removed)
Subject: Re: more student database questions
From: "Steve Schapel" <[email protected]> Sent:
10/7/2003 2:16:16 PM
Ann,
Congratulations on getting as far as you have. However,
it is a
mistake to put the meeting dates in separate fields. In
fact, in a
database it is always a mistake, where there is a one-to-
many
relationship between two entities, to define the data as
separate
fields. In this case, you have a one-to-many relationship
between
Classes and Meetings, and this means another table is
needed. For
example...
Table: ClassMeetings
ClassMeetingID
ClassID
MeetingDate
Then, as regards the Attendance, there is a one-to-many
relationship
between Students and sessions attended. Sooooo.... you
need another
table! For example...
Table: Attendance
AttendanceID
ClassMeetingID
StudentID
- Steve Schapel, Microsoft Access MVP