Yeah usually the foreign key is the primary key from another table.
Say you have a customer table and the headers are:
Customer ID [Primary]
Customer Name
ETC
and then you have an Orders table:
Order ID [Primary]
Order item
Customer ID [Foreign]
The tables link via the foreign key. Creates a relationship, Referential Intergrity FTW! ;D
|