Ok, if I have a table (Title_Author) that has the ISBN and Au_ID (author id) and I want to make sure that the Titles table ISBN column has a PK/FK relationship with the Title_Author table, I should be able to create a relationship to (just) the ISBN column. No? Well, the CONSTRAINT x FOREIGN KEY clause says it's an invalid relationship.
Ideas?
is the ISBN column the primary key (or part of a composite primary key) on the Titles table?
-Darren
|||Part of a composite key.
No comments:
Post a Comment