View Single Post
  #2  
Old March 15th, 2010, 06:40 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default No relation between tables anymore

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

.