Forms

[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.

 

[John Vinson]

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.

Phone support is available at my standard consulting rates. They're
not particularly cheap, and I have an eight hour minimum. How's your
budget?

So instead, let's try to resolve this here. For this application you
need to "normalize" your data - you'll need at least the following
tables:

Students
StudentID
LastName
FirstName
<other personal info>

Classes
ClassNo
ClassName
<info about the class itself>

Enrollment ' resolving the many to many relationship
StudentID ' who's enrolled in a class
ClassNo ' which class is it
<other info about this student/this class>

Jobs
JobID
JobDescription

StudentJobs ' another many to many
StudentID ' who's doing it
JobID ' what they're doing

You'll want to use Forms (say a form based on the Students table) with
Subforms (based on Enrollment and StudentJobs) to enter data.

John W. Vinson[MVP]

 

[Guest]

John,

I will attempt to create separate tables. What's your rate? (per hour).
Thanks for your help.

John

 

[John Vinson]

John,

I will attempt to create separate tables. What's your rate? (per hour).
Thanks for your help.

John

I prefer not to post it here; while I accept work which comes from the
newsgroup, that's not why I post. You can email me offline: make the
obvious fixes to my email address.


John W. Vinson jvinson *at* WysardOfInfo *dot* com