View Single Post
  #5  
Old March 15th, 2010, 06:59 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default No relation between tables anymore

hubertholz,

Karl gave you a solution but I would suggest you review the below (they are
all FREE)...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

Please note, all help, with the exception of Steve's, is FREE. So... should
you additional help please post back and everyone else will help you for
FREE!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"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