Tables & Forms

[Guest]

Hi,

I have this issue with the school database. I'd like to speak with someone
over the phone to solve this. First let me explain the problem.

I have a table that stores all the student info.
I have another table that stores all the students Classes.
When I go to the form, I like to enter the student to a class with all the
other info.
I like to be able to go again to add the same student to another class, but
not having to re-enter the other personnel info again.
Currently, every time I add same student to another class, I see the
student's name twice. I really need desperate help. If someone can please
help me over the phone, that would be great. You can email me to leave a
phone number and a best time @ (e-mail address removed). Thank you so much.

 

[John Vinson]

Hi,

I have this issue with the school database. I'd like to speak with someone
over the phone to solve this. First let me explain the problem.

I have a table that stores all the student info.
I have another table that stores all the students Classes.
When I go to the form, I like to enter the student to a class with all the
other info.
I like to be able to go again to add the same student to another class, but
not having to re-enter the other personnel info again.
Currently, every time I add same student to another class, I see the
student's name twice. I really need desperate help. If someone can please
help me over the phone, that would be great. You can email me to leave a
phone number and a best time @ (e-mail address removed). Thank you so much.

You're not taking advantage of the fact that Access is a relational
database.

You need THREE TABLES: Students, with one record per student (and no
class information at all); Classes (with information about the class
as an entity in its own right, with no student information); and
Enrollment, with the StudentID and ClassID as links to these other two
tables.

Use a Form based on the Students table, with a subform based on
Enrollment; on the subform you can have a combo box based on Classes
to allow the selection of a classID.

Private EMail support and telephone support are generally available to
paying customers. My fees aren't particularly cheap and I have an
eight hour minimum, so you'll do better to just ask for help here,
unless you've got a substantial consulting budget! A response by EMail
will get you a copy of my consulting terms, if you're interested;
questions by email will get you an invoice.


John W. Vinson[MVP]