TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Adrián Pérez Camarena <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 6 Dec 2017 16:42:18 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (19 lines)
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.

ATOM RSS1 RSS2