On 19 Feb 2013, at 3:01pm, Thomas Knox <kno...@gmail.com> wrote: > Is it possible to use a field in a VIEW as the foreign key for another > table?
No. If this truly is the database structure that's useful to you I would suggest that either (A) you enforce your foreign keys in your software and not have SQLite do it or (B) you create and maintain another TABLE which exists purely to act as the foreign key index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
