Jeffrey, thanks for the advice - I hadn't realised there was a Makers view, and it looks very useful.

As a more general point for the entire list - does anyone have a list of what (some of) these pre-loaded views do, that they'd be willing to share? Or would anyone like to send in details of specific views they find useful, and I'll pull a list together myself and circulate it? I haven't found anything in the system documentation that lists what they do, and there seem to be quite a lot of them. (I can identify most of the views that drive data views, list views, and reports from their names - it's the other ones that are the problem!)

Best wishes

Rupert

Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]
Tel: +44 (0)20 7747 5921

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey
Sent: 31 May 2018 13:42
To: [log in to unmask]
Subject: Re: Query

Try using the Makers view (not a table) and link via Objects.ObjectID = Makers.ObjectID. This will get you all the artists, and anyone else associated with the creation of the object.  This query should do it:

select o.objectnumber, m.displayname
from objects o inner join makers m on o.objectid = m.objectid
order by o.sortnumber, m.alphasort

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Adrián Pérez Camarena
Sent: Wednesday, May 30, 2018 6:10 PM
To: [log in to unmask]
Subject: Query

Dear friends,

I'm trying to pull out a list of records of the Objects table via a query of SQL Server. This list must contain the Constituents (Artist Name). I am wondering which tables and fields besides Objects table are involved to pull out the list I need, specially need to know which field in the Constituents table matches on a field in Obejcts table in order to link both fields and obtain the Artist name of every record that lives in Objects table. Or if there is another table involved besides Objects and constituents, I'll appreciate your advise


¡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.

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.