Adding a Subform

[Guest]

Hello,

I homeschool my daughter and I use Access to keep track of her information.
Anyway, I'm wondering if I can somehow put two forms together. I have one
form to keep track of her attendance and one form to keep track of her
grades. In the attendance form, I checkmark all the subjects that she has
done for the day. I was wondering if I could somehow make a relationship
with the dates so that I could put subforms together so I don't have to
manually check what subjects she has done for the day. I would rather the
subjects/grades show up for each day on the attendance form.

Does anybody have any ideas?

Thank you!!

 

[Arvin Meyer [MVP]]

You can use a subform for grades (or attendance). If grades are a daily
occurence per subject, then the grade data is an attribute of the subject,
as is the attendance. Each record should have:

Subject
AttendanceDate
Grade

and that data should reside in 1 table.

 

[Guest]

I'm sorry, I don't understand. Thank you though.

Both tables (tbl-Attendance & tbl-GradeBook) have a date field named Date.
Only the GradeBook has subject & grade though. I actually use queries for
the forms because I use a formula to come up with the actual letter grades.

Are you saying that I should have the date field named differently in each
table?

Jody )

 

[Arvin Meyer [MVP]]

Date fields should never be named "Date" because that is a reserved word.
But that's not the point I was making. Are the grades a daily occurence per
subject? If yes, you need only 1 table, If no, then 2 tables. The common
(join) field for 2 tables is the StudentID.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

No, she doesn't neccesarily do every subject every day. Is that what you mean?

I changed all my "date" fields to a different name. Thanks for the tip! I
also added StudentID to all my tables. I didn't do this since she's my only
student, but now I see why that is important.

Thanks for your help.