David: >From what I can see of your code below, you forgot to put 'PRIMARY KEY' after the 'keyword' column in 'artist_keywords'.
Karen >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)+ > ) < ================================================ 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
