Print Page | Close Window

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


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,...Wink



-------------
http://www.web2messenger.com/theboss">



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net