I am having a problem thinking out the logic for a Threaded discussion Messageboard.<BR><BR>I have one table with the following columns<BR>ID - int Primary Key<BR>Title - varchar<BR>Author - varchar<BR>Message - varchar<BR>datetime - date<BR>parentid - int<BR><BR>ParentID is the ID of the Message of the user replied to. Ifthe user is posting a new thread then the parentid is set to zero.<BR><BR>I have tried joining hte table it is self, and every thingworks fine if the thread only goes one replay deep, but if it goes mroe than one replay deep I can not see to figure out how to make the logic work. Any Suggestions<BR><BR>SKOOTER<BR>