TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

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

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

Print Reply
Mime-Version:
1.0
Content-Type:
text/plain; charset="UTF-8"
Date:
Wed, 6 Dec 2017 16:42:18 -0500
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
Content-Transfer-Encoding:
quoted-printable
Message-ID:
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
From:
Adrián Pérez Camarena <[log in to unmask]>
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