Hi Again - and thanks!
> > Well, you have a few choices: > > a) you could have one table for books read and one for the books still > to read, and when you've read a book you have the database transfer the > record from the one table to the other. > > b) you could have a table for all books, and a flag in the table to > show when it's read > > c) you could have a table for all books, and another table with your > rating and such details that gets a record added when you've read the > book > So my thought was to have three tables - *Table - BooksRead* Author Book SeriesName (can allow Null because most books are not in a series) Pages *Table - Series* SeriesName (not unique per row) BookName (This + SeriesName would be unique) Read (binary true/false auto set dependeing on if the book is in BooksRead or not) *Table - Rating* Each category (ie, story, ending, character development, etc...) Overall - auto calculated based on combo of other values (here I'd love to have some kind of graphical representation of my ratings, like stars, incremented by half star, 1-5 star total) *So then what would be left is:* Figuring out how to summarize my data like I do in the spreadsheet (pages read per year, pages remaining, pages read per month, etc....) Figuring out how to get some printout of "next book in series" - I suspect some kind of query would work that checks in "Series" table and finds the "next" book in a given series that does not have a true value in "Read" field. In spreadsheet I was going to use match/index to accomplish this. Other cool things like summarizing my opinions of particular authors, a list of "want to read" books independent of the series. Possibly add genre somewhere and a randomized "suggest a book" thing. At some point I'd love to figure out how to pull series data from some source so I don't have to manually add books that are in a series. Some series have 50+ books, entering them all manually might be brutal ;) Sound feasible? Best, Joel -- *Joel Madero* LibreOffice QA Volunteer [email protected] -- To unsubscribe e-mail to: [email protected] 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
