L
ladawnd
/ I had some major typos the first time I asked these questions and I have no
response so far, so I'm editing my question for clarity. Thanks for your
help. /
I maintain an Access database of Volunteers for our elementary school. Last
year I kept everything in a flat table to make things quick and simple.
This year I have a database with three tables. Teachers, Students and
Parents. There is a one to many relationship from teachers to students. The
student database has a field called teacher that is linked to the primary key
of the teachers. The form that I use for data entry has a drop down list of
possible teachers.
And there is a One to many relationship between parents and students. The
student table has a field called parent which is linked to the primay key of
the parent in the parent table.
Each parent has certain things they volunteered to do. I need to create a
list for each teacher that shows which parents have volunteered to do what.
Each parent may show up in more than one teacher's list.
I want the report to include student and parent information and by sorted by
teacher. When I use the wizard to create a report, the student information
is all complete, but the parent information is all blank. It does sort by
teacher, and as best as I can tell the information as to which student is in
which teacher's class is pulling up correctly. However, rather than
printing the teacher's name it is printing their Primary Key. I can
manually fix that in Word, but I'd rather have Access print their name.
I used to do tech support for Novell for a living. I'm computer literate,
Office Proficient, but not a Visual Basic Programmer. I have taken a class
in Pascal about 10 years ago. I understand basic database design concepts.
My husband just finished a college course in SQL, but he knows nothing about
Access. I don't know much about SQL. I have never taken a class in Access.
I need an Access for Dummies tutorial. Everything I've researched is either
too simplistic or too complicated.
Any suggestions on how to do this? I'm willing to RTF, but I can't find what
to read. Thanks!
ladawnd at gmail do not spam me dot com
response so far, so I'm editing my question for clarity. Thanks for your
help. /
I maintain an Access database of Volunteers for our elementary school. Last
year I kept everything in a flat table to make things quick and simple.
This year I have a database with three tables. Teachers, Students and
Parents. There is a one to many relationship from teachers to students. The
student database has a field called teacher that is linked to the primary key
of the teachers. The form that I use for data entry has a drop down list of
possible teachers.
And there is a One to many relationship between parents and students. The
student table has a field called parent which is linked to the primay key of
the parent in the parent table.
Each parent has certain things they volunteered to do. I need to create a
list for each teacher that shows which parents have volunteered to do what.
Each parent may show up in more than one teacher's list.
I want the report to include student and parent information and by sorted by
teacher. When I use the wizard to create a report, the student information
is all complete, but the parent information is all blank. It does sort by
teacher, and as best as I can tell the information as to which student is in
which teacher's class is pulling up correctly. However, rather than
printing the teacher's name it is printing their Primary Key. I can
manually fix that in Word, but I'd rather have Access print their name.
I used to do tech support for Novell for a living. I'm computer literate,
Office Proficient, but not a Visual Basic Programmer. I have taken a class
in Pascal about 10 years ago. I understand basic database design concepts.
My husband just finished a college course in SQL, but he knows nothing about
Access. I don't know much about SQL. I have never taken a class in Access.
I need an Access for Dummies tutorial. Everything I've researched is either
too simplistic or too complicated.
Any suggestions on how to do this? I'm willing to RTF, but I can't find what
to read. Thanks!
ladawnd at gmail do not spam me dot com