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 |
Thread Tools | |
Display Modes | |
|
|