Fellow Programmers,
 
Here is the scenario:
Table1 name: Projects
Table2 name: Events
Table2: Pr_ID is foreign key representing Event.Name record number.
 
 
I want to be able display a record from the Projects table such that when a Project.Project_Name is associated with several
Event.Event_Name records, only one line will display with  Project.Project_Name. On the same line I want to display all associated
records from Event.Event_Name in either a dropdown list box or URL links.
 
Currently using various "JOIN" methods does not produce the results I need. Can you suggest a solution? Thanks.
 
Eric