On Sun, 30 Jul 2006 06:12:02 -0700, Ziad
<Ziad[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >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
>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
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]
|