The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
In the past i used to catalog my book in a simple table. But i found this to be clumsy as a book can have multiple authors and editors, can contain multiple stories and belong to different categories and genres. So i decided to use a database. Designing the database is relatively simple, the problem is designing a convenient input mechanism. I tried using access, but i only succeeded in making very sipmle forms, nothing that could handle all the many-to-many realtionships.
I'm certain other people have had this same problem. Any advice?
You could try using an already existing solution. I don't have quite so many books as to need a database to keep track of them, so I haven't tried these.
Posts
http://www.spacejock.com/BookDB.html
http://www.collectorz.com/book/
I'm sure there are others. These may not fulfill your purposes, but they're at least start.
So, I tried this. It has the advantage that you can share your library records online. But it's also annoying to add non-english books.