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
Sue Garton
Data Administrator
Smithsonian
National Portrait Gallery
[log in to unmask] | 202.633.8554
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.