filling a table based on data from another one?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ziad - 30 Jul 2006 14:12 GMT

Hi
i'm really new at this i've searched in a book i have and i couldn't find
any thing and i need some help

i'm working in my school we have 4 majors for each major a table with it's
courses

and a(NewStudent) table for the new students, this table contains their id
,names,the majir they
want to be in ,and if they want to take the full courses or part. and
another table
(NewStudentCourses)for the courses they will register in.

i'm working on the form that will be used to new students registration , i
want it if the
student pick the major-as a combo box- and full courses-as an option group-
,the courses in that major will automaticly be in NewStudentCourses table
with his id
but if he pick part, the courses opens in a new form-subform-(or any good
idea)
so he can pick the courses he want and also they will be writen in
NewStudentCourses
table.

i'm realy hopeless :S

Reply to this Message

John Vinson - 30 Jul 2006 16:22 GMT

>Hi
>i'm really new at this i've searched in a book i have and i couldn't find
>any thing and i need some help
>
>i'm working in my school we have 4 majors for each major a table with it's
>courses

Then you have an incorrectly designed database. You should have *ONE*
table of Courses, with a field for Major. That way if you add a new
major, you can simply add new records to the table, rather than create
a new table, revise all your forms and reports, etc.

>and a(NewStudent) table for the new students, this table contains their id
>,names,the majir they
>want to be in ,and if they want to take the full courses or part. and
>another table
>(NewStudentCourses)for the courses they will register in.

Do you also have a Student table? If so, again - just use one table
for students, new and established.

>i'm working on the form that will be used to new students registration , i
>want it if the
[quoted text clipped - 8 lines]
>
>i'm realy hopeless :S

You'll need to run an Append query appending records from the
(redesigned) course table into NewStudentCourses. This query can be
called from VBA code or from a macro.

John W. Vinson[MVP]

Reply to this Message