Remote Key Question

Hi gang: A few times I've found myself confronted with a problem that might be better solved than the way I currently solve it. I would like your opinions/solutions as to how you might solve this. Here's the given (as an article/author example). I want to create a list of articles in a database. The articles are listed in a table with the fields "title", "description", and "author". article table: id - title - description - author The authors are listed in a table with the fields "name" and bio". author table: id - name - bio Now here's the problem each articles will have one, but perhaps more authors -- so how do I record the authors in the article table? As it is now, I use the remote key for each author and separate each key by a comma in the author field of the article table. For example: author table: id - name - bio 1 - tedd - tedd's bio 2 - Rob - Rob's bio 3 - Daniel - Daniel's bio article table: id - title - description - author 1 - PHP Beginner - Beginner Topics - 1 2 - PHP Intermediate - Intermediate Topics - 1,2 3 - PHP Advanced - Advanced Topics - 1,2,3 As such, article with id=3 has a title of " PHP Advanced" and a description of "Advanced Topics" with tedd, Rob, and Daniel as authors. Is there a better way to link multiple authors to an article rather than placing the remote keys in one field and separating them with commas? Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com