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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|