dear all,

I do need some help..
I'm working on a library project. There are 3 related tables : TAuthor, Tbook and TBookAuthor. TAuthor is a table for author's information, TBook is a table for book's information, and TBookAuthor is a table to store information (cBookID & cAuthorID) that relate TAuthor and TBook, because a book may have more than one author.
The problem is i want to browse the information of the book in a grid, where all of the author name of the book will be appear in a single column. I'm going to use it to display the result on searching process too.
I've thought about add a new table that contain 2 fields: cBookID and cAuthorName, where cAuthorName is filled by all of the authorname in a book that will be seperated only by a comma. But i'm not sure that's a good idea because i can't determine the best length of the field, it could be too large or too small.
What should i do? Any comment will help me... thank's before...


Love,
Gloria


"a new day means a new hope"