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.