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?
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.