Hi, Does anybody know how to access the records in the RECURRINGGIFTACTIVITY table? When I create an object of type CRECURRINGGIFTACTIVITY, the only attribute/method I get is 'Fields'. What I'm actually trying to do is to get the associated Recurring Gift (from which we get the current Membership renewal unit and renewal period from the renewal schedule) for the current Gift Transaction so we can create a new Membership Transaction depending upon certain criteria. Sounds confusing to me too! Thanks for your time, Cheers, Gary Hay The Wilderness Society Hobart, TAS, Australia

Have never tried to access the RECURRINGGIFTACTIVITY onject but to get from a Recurring Pay Cash gift to its parent Recurring Gift use the field oGift.Fields(GIFT_fld_EFT_Id). This gives you the record id of the Recurring gift so you can load it as below Dim oEftGift As CGift Set oEftGift = New CGift 'get the recurring gift oEftGift.Init REApplication.SessionContext oEftGift.Load (oGift.Fields(GIFT_fld_EFT_Id))

Thanks Peter. I tried lots of other things but didn't realise that the EFT_Id field was the one. Cheers, Gary.