The mediaXrefs table provides the link between Objects and MediaMaster tables.

Objects.objectID=mediaXrefs.ID

mediaXrefs.mediamasterID=mediamaster.mediamasterID

I suggest asking GS technical support these technical questions. Brian and Dimytri respond quickly and are very technically adept. 

David Parsell

Yale Center for British Art

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Adrián Pérez Camarena
Sent: Wednesday, December 6, 2017 4:42 PM
To: [log in to unmask]
Subject: Tweaking a quey

Hi dear friends,

I would like to know how can I update the check "Public Access" from the Objects module and from the Media tab in the same module executing a query from the data base and which tables are involved in this query and what is the field that makes the link between Objects table and MediaMaster table. I can not find a field that makes the link between this two tables, I think there must be a third table.

I have to update about 1000 records and I would like to do it with a query.

Has anyone else come across this a managed to resolve it?

Thank you.

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.