Tables

[Ashley Horsley]

Hi,
I was wondering if you could help, this is for my A-Level
in ICT.
I have to create a database in which students details,
and course grades are stored. The database is required to
store the names of the courses that the person is doing
in one table and then in a different table the name of
the course will automatically appear when the student is
selected. I have a bit where the student is selected from
a drop-down box, but I want the value that is selected in
a different table which is the course name, to be put in
a box on this table.

I hope you can help
Many thanks

 

[Lynn Trapp]

Ashley,
Actually, you do NOT want to store the name of the student in 2 tables. Only
store it in the one table with the student's information and store the
unique identifier of the student in the courses table. You will need to do
this through a form, also.

For future reference, you should not post separately to so many newsgroups.
If you need to post to multiple newsgroups, you should put the address of
all of them in one message. That way any responses you get will appear in
all groups.

 

[Craig Alexander Morrison]

Do not multi-post