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!

how do you know it's the same John Smith???????

umm...well the application deals with fishing captains who sometimes operate from two different locations...that's how I know for a fact and without a doubt that the john smith who has a fishing boat in chicago is the same one who runs a bass fishing operation in orlando.

What happens when another John Smith moves to Orlando and starts fishing?