A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

No relation between tables anymore



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2010, 04:08 PM posted to microsoft.public.access.tablesdbdesign
hubertholz via AccessMonster.com
external usenet poster
 
Posts: 4
Default No relation between tables anymore

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

  #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

.

  #3  
Old March 15th, 2010, 07: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



  #4  
Old March 15th, 2010, 07:14 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default No relation between tables anymore - stevie PIMPS again!

"Steve" wrote in message
...
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

  #5  
Old March 15th, 2010, 07: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

  #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



  #7  
Old March 16th, 2010, 12:11 AM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default No relation between tables anymore


"Steve" schreef in bericht ...
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.



--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


  #8  
Old March 17th, 2010, 08:19 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default No relation between tables anymore

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.



  #9  
Old March 18th, 2010, 05:22 AM posted to microsoft.public.access.tablesdbdesign
hubertholz via AccessMonster.com
external usenet poster
 
Posts: 4
Default No relation between tables anymore

Anyway,

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1

  #10  
Old March 18th, 2010, 05:39 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default No relation between tables anymore

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

"hubertholz via AccessMonster.com" u58479@uwe wrote in message
news:a52ccd9f98399@uwe...
Anyway,

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.