I have one big table that contains all this information inclusive the
grades and 8 other tables, that will store the grades yearwise and per
subject.
All grades should be in a single table with field for year and subject.
Then set a one-to-many relationship from student to grades.
--
Build a little, test a little.
"hubertholz via AccessMonster.com" wrote:
Hello
I have been working with database since a couple of weeks now. The idea was
to create a database that contains information about a student such as email
adresses etc. However, in addition to that, it should also contain the
subject combination of this particular student and according to that, the
grades. I have one big table that contains all this information inclusive the
grades and 8 other tables, that will store the grades yearwise and per
subject. As a relationship I have set one-to-one.
Everything has worked well until now. I was able to print reports and
everything.
I do not quite know what has happened, but whenever I enter a new student now,
it appears in the student table in the related tables as well, but it I can
neither run a query to find information about the student nor see him in the
data input form.
I am really stuck since I do not know a lot about databases..
Is there any chance of helping me? I know that it will be rather difficult to
obtain the issue from my describtion, but maybe I am making a typical
beginner's mistake?
Please let me know..
Hubert
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1
.