listing data

[catscout]

In a database i've a record with 2 people in each record, with her (his) own adress. How can I make a sorted list, with a subsumary leading, with the people thar lives in the same adress. In the form that I use the 2 people in the record appears

[Ocean West]

The easiest way is to create a seperate database where you can import twice once for the first person per record and another time for the 2nd person on the record. Then this database would contain one person per record where you then can print a sub summarized report showing all persons.