Sorry, I accidentally included 'INTEGER' before 'REFERENCES'. Should have been
CREATE TABLE category( category_id INTEGER PRIMARY KEY AUTOINCREMENT, category_name TEXT ); CREATE TABLE recipes_in_categories( r_i_c_id INTEGER PRIMARY KEY AUTOINCREMENT, recipe_id REFERENCES recipe_data(recipe_id), category_id REFERENCES category(category_id) ); Simon.