Best method to implement multiple series for 1 book
I sometimes encounter a book which belongs to more than 1 series (spin-off/cross-over/re-issue, etc.). Up to now I did not bother (it seldom happens) so I just included a separate identical book copy for the other series. Problem solved.
Or is it? I have now 2 identical copies of the same book in the DB, and each is to be maintained separately to keep them in sync. Not handy. Also space-wise.
So I started thinking about a better solution with just one physical book entry: for instance adding a second "series" column to the book (would that work?) or do something with links (to a dummy book entry for the other series?)
So my question: has somebody tried this already and found good/better solution? What is advisable?
|