The conventional wisdom in Access is that one book title = one author -- and that's true for the majority of the books I'll be adding to this database now being designed. However, in this database I'm creating one book will frequently have several authors due to the collaborative nature of the university. How is a one title = many authors handled in Access?
Thank you.