Query on Unlinked addresses

I am currently unable to query to audit any records which should have linked addresses and do not (spouses for example). The workaround is to export all of your constituents addresses with the linked field and sort them. If you have weekly or monthly auditing queries – this should be able to be one of them without all of this work. Once I have them in excel am I supposed to import them to a query or add an attribute to be able to find them all or look them up one at a time? If you import them to a query the ones you have fixed stay in your query and you have to keep track in your list where you left off in your cleanup. This is especially important for those of us who imported our data because apparently conversions can’t link addresses or something???

  • Guest
  • Jun 19 2012
  • Attach files
  • Guest commented
    March 17, 2016 23:22

    ANY one-to-many or many-to-many data link should have it's own Query and Export type so that each of the records on the "many" side can be queried on, exported, manipulated, and re-imported.

  • Guest commented
    March 17, 2016 23:22

    I have the same problem. I am trying to clean up the unlinked addresses from our data conversion, and I want to be able to run a query, to identify the records, and then link the addresses.