How to inseart foreign key

[deepmob]

i am creating a database and i had created two tables one is holidays and second is departure date.. in the holidays table the primary key is holiday code.
and in the departure date table the primary key is Departure Key and there is also field is Holiday Code. now i had create two tables and then i had insert both the table in one but the problem is this when i am changing the primary key's data of holidays table but the rest field is not changing.. i think its need to assign foreign key but i don't know how to do that can u plz tell me how to insert the foreign key.

i doing my assignment and i am stuck here plz reply me soon so that i can move further..

 

[The_Doc_Man]

Since you admit this is an assignment, I will point you where you need to look but won't do more than that.

To make a foreign key link back to its primary, you must explicitly declare a relationship between the main and secondary tables that links the two fields - parent and child, master and slave, whatever terminology you use. THEN if you want things to be automatic you must use a QUERY that exploits the relationship by having both tables contribute to the query. With a defined relationship, Access will help you. Without that relationship you are forced to do all by hand, which ain't fun.

 

[jdraw]

Here's a M$ reference for SQL and DDL that might be useful. Don't know the level of your assignment, but this does deal with primary and foreign keys and indexes.

"http://msdn2.microsoft.com/en-us/l...ibrary/aa140011(office.10).aspx#acfundsql_ddl

 

[jdraw]

http://msdn2.microsoft.com/en-us/library/aa140011(office.10).aspx#acfundsql_ddl

I think this is the proper URL. Sorry for any confusion.