A join table between the book and author table that allows each book to have more than one author and each author to have more than one book.
Thanks. I have already created that join table. But I still wonder whether the script suggested in the referenced thread above will deal with my situation where several books have more than one author.
Considering these 2 lines from Phil's post:
I'd consider setting up the join table right off as a book can have multiple authors and an author can write multiple books. The same script can create both the author records and the join table records at the same time.
Duplicate author records will not be created as long as your author names are accurate in the Library table as these steps create a new record only if a matching related record does not already exist
Thanks Steve. I'm not sure I am following however. Are you saying the script suggested by Phil will do the job for me even though some of my books have multiple authors (in the same Authors field)?
As further clarification, in the Authors field of my Books table, the authors (3 in this exemple) are shown like this right now, separated by a carriage return:
Will the suggested script create three separate records?