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.