*** 18,23 **** --- 18,25 ---- **The Solution** + (There is an {link: http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator online tool} which automatically generates the triggers proposed below based on the input CREATE TABLE statement.) + The trick to getting SQLite to enforce foreign key constraints is to use its marvelous trigger functionalilty. Here's an example. Say you have two table declarations: