Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Thu, 7 Dec 2017 12:39:05 +0000 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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.
|
|
|