linking tables

  • Thread starter Thread starter nevje
  • Start date Start date
N

nevje

when i link a table to another, so far ive been linking to the prim key
but if the prim key is of a different data type such as say autonumber
linking to a text field does that mean i should be linking them
elsewhere in the table to a field with same data type?
 
when i link a table to another, so far ive been linking to the prim key
but if the prim key is of a different data type such as say autonumber
linking to a text field does that mean i should be linking them
elsewhere in the table to a field with same data type?
Click to expand...

The linking field MUST - no options! - be of the same datatype. An
Autonumber primary key should be linked to a Long Integer foreign key.
It cannot link to text.

You will also find that it's very, very rare that one would link from
a Primary Key to another Primary Key - doing so creates a one-to-one
relationship, which is the least common relationship type.
 
Back
Top