I have a database with 3 separate tables, and each table has it's own primary key. However each table will be linked together using these primary keys. Do I need to define each primary key of all the tables in each table?
For examle, if I have table 1 with Primary Key A, and Table 2 with primary key B. Table 2 will be related to Table 1 using the Primary key A so do I need to define the primary key A in Table 2? Or is there a way I can just link to it without having to redefine it?
I hope that doesn't sound to complicated.
Thanx,
Chris
For examle, if I have table 1 with Primary Key A, and Table 2 with primary key B. Table 2 will be related to Table 1 using the Primary key A so do I need to define the primary key A in Table 2? Or is there a way I can just link to it without having to redefine it?
I hope that doesn't sound to complicated.
Thanx,
Chris