General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Combining the contain of some records
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"
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only