Query has a Constituent shown as active member but is not a member

Constituent paid for another constituent to have a membership. In query both constituents are showing as active members, though only one constituent has the membership listed on their constituent page.
Ensure that within the membership query filter that: Member > is dropped = No and Member > Membership > Status = Active, to show all members that are active. 

Steps to Duplicate

1. Click Analysis tab
2. Click Information Library
3. Search for Query:
4. Click Edit Definition
5. Add Include records where: Lookup ID is equal to x
6. See Status = Active
7. Click Constituent tab
8. Search Constituent
9. Click Membership tab
10. See Constituent has no memberships 

Environment

 Blackbaud CRM
 4.0
 4.0.166.0

Was this article helpful?