View Single Post
Old 01-22-2008, 07:29 PM   #1
Join Date: Aug 2007
Location: Miami, Fl
Posts: 8
Default Distinct records dataset display

Hello Everyone, back again with some more questions for the group!

I'm developing a database driven application in which I show a group of people. I have a database of people in which some individuals have more than one instance of address or location. On my database this is shown as a duplicate record. (example below)

Whenever I try to display the record in an ASP dataset within my page I get duplicate instances of the same record (which I know is logical taking into account the way it's laid out on the database). My question is: are there any ways around it? is there a way in which I can display just one name and then two instances of all their biographical info?

Thank you!
Dreamweaver Club on Facebook!
garp2100 is offline   Reply With Quote