WTF? Foreign keys??

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?

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.

these are keys from the alien word and hence called forigen keys.. just toss them in ur pocket and walk away,...