The last version of SQLite supports foreing keys but with limits on "on update/ on delete" triggers (you have to specify how many times the trigger needs to loop in rows to check the keys ). For more info read the SQLite documentation searching for "foreing keys support".
Anyway, you could code for that.... and this tool could help: http://www.adobe.com/devnet/air/flex/articles/sqlite_db_api_in_air.html
See you. F.
"Beginning with version 3.7.0, recursive triggers are enabled by default but can be manually disabled using PRAGMA recursive_triggers. The SQLITE_MAX_TRIGGER_DEPTH is only meaningful if recursive triggers are enabled.
The default maximum trigger recursion depth is 1000."