SQLite Forum

How to relate a row with more than one topic? See example
The usual way to model an N-to-M relationship, where N and M can be anything greater than zero, is with a separate link table. For your example, it would have columns that might be named Topic_id and Quote_id , which would both be foreign keys into the Topics and Quotes tables.