You cannot link the same FK to 2 different tables.
>i've encountered a problem trying to add more relations to my database.
>in a nutshell i have 3 tables:
>
>T1.Pk and other columns
>T2.Pk and other columns
>T3.Pk and other columns
>
>i already have the following relations:
>Foreign key / Primary Key
>T2.Pk / T1.Pk
>
>i try to add
>
>T2.Pk / T3.Pk
>
>
>i get an error message to do with T3.Pk. All the Pk columns have the same basic properties.
>I tested this kind of relations on a different set of tables with the same result - i can't add a relation.
>
>Can you help?
>Tia
--sb--