CiviCRM Community Forums (archive)

hi simon,
short of writing a custom search, i believe the following, though a bit clunky, would work for you.

1. depending on your configuration, search for all contacts or search separately for individuals etc...
2. select export contacts from the "actions" drop-down list
3. choose "select fields for export"
4. choose the fields you want in the export file, including the relationship fields e.g. "household member of"
5. export the list and then manually get rid of any records that do not have relationship data

alternatively and depending on how many relationship-types are configured, you could use advanced search and search, one by one, for each relationship-type, export each data set and then "merge" them together as one.

it's clunky but i think it will work.

hope this helpds,
cynthia