Forms and Subforms

[Guest]

I have a school database that I'm trying to use to keep track of the
student’s (personal info) + job info + classes + etc...

It was working fine, until I decided to add some students again for
enrolling into another class. I am using another form to create a class and
add the student into the class. However, when I try to go to the main form,
I have to add the personal info and job info again for the same student. My
form is a single data form not a datasheet. I really appreciate if someone
can explain to me how to proceed. If possible, over the phone preferred.
Thank you in advance. If interested in a phone conversation, please email me
your phone: (e-mail address removed). Thank you so much.

 

[Guest]

I'm not sure what you mean by "single data form not a datasheet", but if you
mean all of this is in one table then you are not following relational
database design rules. Considering just the students and the classes you
will need a Students table, a Classes table, and an Attendance table. Each
student can be in many classes, and each class can be attended by many
students. This means there is a many-to-many relationship between students
and classes, so the Attendance table is needed to resolve the relationship.
If you describe your table structure and relationships it may be possible to
get you pointed in the right direction. If what I have said sounds foreign
you should become more familiar with the language and methods of relational
databases. One way is to search for Access tutorials on the internet. You
could browse the Getting Started group for leads and tips.