Please assist.
I have 2 tables. One is called COMPLETED (AUTHOR as Primary key) and the other is PROJECT (Project Number as Primary Key)
I have many AUTHOR associated with One Project Number. On my list page, I want to list fields in the PROJECT table and all of the AUTHORs in the same column (seperated by <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1281&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />. I do not want multiple rows of the same Project Number with different AUTHOR.
I know I can create a link that would display all the authors related to this project but it is critical that I can display this way because the User needs to see the find the author without clicking through each record to see who wrote it.
example
Project Number Title AUTHOR
54654 Boxing Tyson, John; Mike, Myers; Don, Merhcan
NOT
54654 Boxing Tyson, John
54654 Boxing Mike, Myers...