append query mmmmh? 1

[Pampers]

hi everyone,
a student application (tblStudent)
a student chooses a study (tblStudy)
a study contains of subjects (tblSubjects)

If the students chooses a study, i want the subjects belonging to that study be inserted into to tblStudentSubjects

You use an append query for this?

Hope this helps (a bit)
Pampers.

You're never too young to learn

 

[flyover789]

there are many threads and info out there regarding relational database design best practice

and here's a good start for you:

http://www.mvps.org/access/tencommandments.htm

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[Pampers]

i know the ten commandments.
i know database relationships
i don't about insert records from one table to another

Hope this helps (a bit)
Pampers.

You're never too young to learn

 

[flyover789]

so why would you create a table tblStudentSubjects?
you already have the information in tblStudent and tblSubjects ...
no redundancies please.

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[Pampers]

hi flyover789,
off course, what was i thinking?
champagne and a star
and eh, i know database relationships a bit better now, haha
tnx for the help


Pampers.

You're never too young to learn

 

[Pampers]

back again,
but what do you do if the school allows a student to have a different subject in the fixed studyprogram? Since, a studyprogram is related to a fixed set of subjects.



Pampers.

You're never too young to learn

 

[flyover789]

you can do anything by the use of table keys and joining the tables through these keys ...
I have the feeling, that you still have to get aware of what a relational database is and works like.
Take a look here:

http://r937.com/relational.html

Best regards,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[Pampers]

yep,
looks like it. But one day we get there... tnx for the article. still looking how to alter the subject for one student with the following structure

tblStudent
StudentID
StudentName
CourseID
m-1
tblCourse
CourseID
Course

1-m
tblSubj
subjID
subj
CourseID




Pampers.

You're never too young to learn

 

[Pampers]

hi flyover,
you mind putting my 'relationship' problem in the relationship forum; looks like a better place


Pampers.

You're never too young to learn