No relation between tables anymore

[hubertholz via AccessMonster.com]

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

 

[KARL DEWEY]

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.

 

[Steve]

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
(e-mail address removed)

 

[John... Visio MVP]

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

Stevie This is within 10 minutes does that get your attention?

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

 

[Gina Whipp]

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/accessjunkie/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

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

 

[Jeff Boyce]

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.

 

[Fred]

I think that Steve's marketing concept is that hitting people up for money
in a free advice forum is like farting in an elevator......you get noticed
only because nobody else is doing it.

 

[hubertholz via AccessMonster.com]

Anyway,

I have sorted that problem out.. Basically I did the whole thing again so..it
worked then

 

[Gina Whipp]

Thanks for posting back... and glad you got it sorted out!

--
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

Anyway,

I have sorted that problem out.. Basically I did the whole thing again
so..it
worked then