> > Yes, but what would go into the Series table? SeriesName and BookName > are already in the BooksRead table, and the read flag just indicates > that it is in the BooksRead table. >
So the Series Table would have all books in a series and this way I could query the next book to be read in a series. So for an example: Book Table: Harry Potter and the Sorcerer's Stone (...) SeriesName="Harry Potter" Series Table: Harry Potter | Harry Potter and the Sorcerer's Stone (Read) Harry Potter | Harry Potter and the Chamber of Secrets (Unread) Harry Potter | Harry Potter and the Prisoner of Azkaban (Unread) .... Then if I set up some kind of a report that told me the next book in the series, when I query "Harry Potter" it would give me "Harry Potter and the Chamber of Secrets" (and possibly list all other books in the series that are not yet read, or list all books in the series, highlight the ones that are unread, or some such thing) What I don't want is my main table to include both read and "want to read" books - I like keeping the "what I've read" completely separate as this is what I'm most interested in for tracking purposes (to meet my goal) and what not. Best, Joel -- *Joel Madero* LibreOffice QA Volunteer jmadero....@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
