03-31-2010, 04:19 PM
|
#5 (permalink)
|
|
Wizard
Join Date: Sep 2007
Posts: 1,299
Thanks: 17
|
Quote:
Originally Posted by fairytale89
isn't that primary key that referring to another primary key in another table is called as 'composite key'?
i'm not not really agree when you said that i'm actually wanted to declare is a unique ID. or, am i wrong in understanding this 'composite key' term? if so, someone please explain to me...
i'm sorry, i'm not expert in database i just started to learn it and stil learn about it.
however, here's the relationship below and i really thinks what i'm trying to achieve is not foreign key but composite key..
|
A primary key can never refer to another table, it is used exclusively to identify each row. What you are looking for is a foreign key, use google to lean about those. |
|
|
|