Dear SQLiters, I am trying to set up what I would call "nested foreign keys":
create grandParent (id PRIMARY KEY ) create parent (id PRIMARY KEY REFERENCES grandParent(id)) create child (id PRIMARY KEY REFERENCES parent(id)) SQLite complains. Does it mean that grand children are not allowed? Thank you, Roman _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users