Yah - SQLite doesn't support foreign keys. Adding foreign keys, though, is very simple. You only need them for modification operations. So, just have all your database access go through four functions - select(), insert(), update(), and delete(). (If you even want to support delete. We don't, on one of our apps.) Then, every call to insert(), update(), or delete() will have a call to select() to make sure everything will remain OK.
------
We are the carpenters and bricklayers of the Information Age.
Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose
I shouldn't have to say this, but any code, unless otherwise stated, is untested