Let's say I want to mail to all parents and grandparents of kids with an interest in violin. Violin interest is logically stored in attributes of the child record. The address I need to mail to is on the parent or grandparent record. This is a nightmare. The records I'm pulling are the parents and grandparents, but in query I can't reach the attributes of the child. I can reach the "relationship" attributes but not the actual attributes that reside in the child's record.

If you try to get around this by querying the child's record, in export you can't reach the preferred address of the parents and grandparents. You can reach the address that's stored in the "relationship" record for that person, but not the actual primary address. Optimally these addresses are linked, but in a database of 50k it's nearly impossible to maintain that. Doing relationship queries and exports have the same issue.

Can you adjust it so that you can reach the actual constituent address and attributes from the drill-down in query and export?