This topic is locked

One to many relationship

3/29/2005 6:07:20 PM
ASPRunnerPro General questions
D
ducmis author

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...

Sergey Kornilov admin 3/31/2005

Hi,
it's impossible with ASPRunner.