Hi Does anybody know how to access the constituent relationships from the VBA/API. Because I am not able to post a screenshot of RE ,the data I want to access is located as follows : [Records] -> [ Constituents ] -> [ Select a Constituent ] -> [ Relationships Tab ] I able to do it using raw SQL on the CONSTIT_RELATIONSHIPS TABLE, which I believe is contained in the collection class CRelations collections class, however, locating this information through the API alone has not been intuitive. Does anyone know how to display all the relationships belonging to a constituent using the VBA/API. Kind Regards

I understand what you are going through! The way that you access relationship information in the API changed a few versions ago. The CRelations object became obsolete so that relationship were no longer accessed directly from the constituent but had their own top level class. You should not use the CIndividual2 and COrganization2 classes to access relationship information. See my blog entry for an example: http://www.blackbus.org/blogs/viewblog.php?username=davidz&userid=349&entrytitle=old-and-new-relationships&entry=20  David Zeidman Development http://www.zeidman.info --- Edited at 3/1/2007 8:00:41 AM by David Zeidman