Hi Enrico, Thanks a lot for the help, it was very useful. I have a bit more testing to do to make sure that I'm always getting the correct records, but your methods seem to be working (and performing much faster) so far!
The main "trick" that I didn't think of was selecting records from the same table in a nested fashion (and of course having a separate table with all of the relationships stored there). Thanks again, Jason _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
