primary key problem

[David Torre]

Hello,

I'm creating the table structure as follows and I'm having problems with 
linking a foreign key to a primary key.  The error occurs after I try to 
create the artistkeys_ln table.

SET FASTFK ON
CREATE TABLE artist_keywords+
  (+
  artistkeys_id INTEGER NOT NULL PRIMARY KEY,+
  keyword TEXT 50 NOT NULL UNIQUE+
  )

CREATE TABLE artistkeys_ln+
  (+
  catalog_id INTEGER,+
  artistkeys_id INTEGER NOT NULL UNIQUE,+
  FOREIGN INDEX (catalog_id) REFERENCES catalog (catalog_id),+
  FOREIGN INDEX (artistkeys_id) REFERENCES artist_keywords (artistkeys_id)+
  )

-ERROR- The referenced table artist_keywords does not
have a compatible Primary Key or Unique. (2770)

-David 

================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l