View Single Post
  #6  
Old March 15th, 2010, 08:00 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default No relation between tables anymore

Before you do business with someone who advertises for-fee services here, be
aware that these newsgroups are (mainly) staffed by volunteers, and that the
Code of Conduct prohibits solicitation. Do you want to do business with
someone who ignores the rules?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"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