I am attempting to export Memberships and Contributions. When I export Memberships, there is no field to export associated Contribution records/IDs. When I export Contributions, there is not field to export the associated Membership (if it was a membership).
Currently, the only unique ID on the Contributions is the Contact ID - but a Contact can have multiple contributions (i.e. membership purchase, renewal, event sign up, etc.)
How can I export the related/associated Membership ID for a Contribution?
Alternatively, I thought it could work to export the Memberships if they included the Contribution amount. But that is also not an option on the Membership export, only Recurring Contribution ID.