Hi Susan They're stored in the Associations table: filter on TableID = 108 for Objects. ID1 is Parent and ID2 is Child in a hierarchical association. Join to Relationships table on RelationshipsID to fetch the related 'terms' for each side of the relationship. Also, there's a table called AssocParents which usefully contains a 'childstring' for Parent records i.e. a summary of the related child records; again filer on TableID = 108 for objects. Hope this helps. Best wishes Jon From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Garton, Susan Sent: 15 December 2016 19:33 To: [log in to unmask] Subject: Object-Object relationships in reports Does anyone know where xrefs for object-object relationships live? I want to include related records in a report but can't find the table where the links live. Thanks in advance! Sue [cid:image001.png@01D16E4E.942FCC80]<http://npg.si.edu/> Sue Garton Data Administrator Smithsonian National Portrait Gallery [log in to unmask]<mailto:[log in to unmask]> | 202.633.8554 To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.