View Single Post
  #3  
Old March 15th, 2010, 06:04 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default No relation between tables anymore

Hello Hubert,

I can help you! I provide help with Access, Excel and Word applications for
a small fee. Your database is not set up correctly. If you send me a copy of
your database, I can set it up correctly and import all your existing data
into the new database. I will do it all for a nominal fee and have you up
and running quickly. Contact me if you want my help.

Steve



"hubertholz via AccessMonster.com" u58479@uwe wrote in message
news:a50cb88f7c3ba@uwe...
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