sounds like a job for hierarchical recordsets.  Have a look at the articles
on 4guysfromrolla.com - they explain it much better than I could (plus i'm
far too lazy!)

HTH,
Col

-----Original Message-----
From: risho@c... [mailto:risho@c...]
Sent: 15 May 2002 19:24
To: ASP Databases
Subject: [asp_databases] Can't display records properly


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


*******

This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.  If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system.  If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.

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