I'm told that there is something Very, Very Difficult about having one book pointing to two (or more) authors. LibraryThing has the same problem.

Clearly, I'm clueless as to what causes the problem database-wise, for a database wiz I am not -- maybe the necessity for keeping a double set of records for each book, one under each author's name?