"FOREIGN KEY(recipe_category_id) REFERENCES category(category_id)"
Thank you gunnar. I don't understand it yet but will work hard at it. Once I make up some dummy data to play with, it might get me a better idea of how all this works. One thing I have no lack of is recipes! My ambition is to one day have a database of several million. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Complex-insert-query-to-normalised-database-tp80590p80629.html Sent from the SQLite mailing list archive at Nabble.com.
