WTF? Foreign keys??
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12893
Printed Date: 01 April 2026 at 5:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: WTF? Foreign keys??
Posted By: Gullanian
Subject: WTF? Foreign keys??
Date Posted: 08 December 2004 at 9:54pm
|
Had a coursework assesment a day or two ago. It was about
database design, and frustrating as it was designing a non-normalised
database in pairs (we haven't learnt normalisation yet so my partner
refused to accept my design) I stuck it out. We had a few basic relationships stuck in there, and produced something pretty scaggy at the end. Came to the assement, and the two assesors looked at our relationship. They pointed to a one to many relationship between a primary key (item_number) holding books and and ordered book table with the item_number in it. Nothing wrong with it really at all. They pointed toit and go, "so why isn't it a foreign key?". I thought it my head, "WTF it is a foreign key". They then pointed at all the relations enquiring as to why they wern't pointed to foreign key. I was bemused! I challenged them and said they were and they just pointed again and said they wernt. Have I missed something? Is there some way of marking a foreign key in access? |
Replies:
Posted By: huwnet
Date Posted: 09 December 2004 at 11:57am
don't think so. 
|
Posted By: WebWiz-Bruce
Date Posted: 09 December 2004 at 2:17pm
|
Usually you give the foreign key the same name as the primary key in the table you create the relationship with. Have a look at the Access database for Web Wiz Forums in table view, it may give you some help. Remember you should also have 'Enforce Referential Integrity' checked. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Gullanian
Date Posted: 09 December 2004 at 4:18pm
| Both had the same names, and referential integrity was forced, I was stumped. |
Posted By: the boss
Date Posted: 09 December 2004 at 5:41pm
|
these are keys from the alien word and hence called forigen keys.. just toss them in ur pocket and walk away,... ------------- http://www.web2messenger.com/theboss"> 
|
