Hi. I'm real new to SQLite via the command line, but I have used CoreData quite a bit on OSX. My problem is that I have two tables that I want to link via a unique ID, but I don' t know how to automatically link the ID parameter properly. My tables look like this:
create table snapshot( id INTEGER PRIMARY KEY, bumf TEXT ); create table sample( snapshotid INTEGER, type TEXT, used INTEGER ); Now when I insert an entry into the snapshot with: insert into snapshot (bumf) values ('one'); I want to insert a number of entries into the 'sample' table and make sure their 'snapshotid' value is set to the one just created in the previous 'insert into snapshot...' command. I know that this stuff is possible because CoreData does this sort of thing but hides it behind a nice API. How do I create such a relationship with sqlite via the command line ? One more thing... the online references I've found for SQL and SQLite seem very basic and don't talk much about linking tables together and things like many-to-many relationships... Can anyone recommend some more thorough documentation, either electronic or in print ? Thanks for your patience. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users