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

 

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.

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.