Distinct records dataset display

[garp2100]

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 on the url)

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!

 

[Sheco]

Yes it can be done.

The best way is probably to write a SQL query that accomplishes this goal. If this is not possible it can be done programmatically in the ASP logic by modifying the logic in your loop.