Hi Matt,

I had been using separate roles for "circle of" etc. as this is what our Gallery Systems trainer said years ago. However, if one searched using "artist" none of the "circle of" or "workshop of" records  would appear. So then, I thought using the prefix field would be the way to go - only to realize after I made the change that the prefix field was not included in any of our reports or views.  I heard back from the Baltimore Museum of Art, they use the prefix field and include a " if then else" sql statement in their reports and views.

Good luck with your IT department. Other than housing the server, our IT department was not much help when it came to launching emuseum. Luckily my husband is a sql programmer extraordinaire  and he has done most of the work for us - with my supervision of course.

Best,

Lucille
On Wed, Dec 12, 2012 at 9:32 AM, Matt Conway <[log in to unmask]> wrote:

We do separate constituent records for each variation.  All of the various choices should come up, though, when searching for, or entering a new record for anyone named “Doe.”  It seems to work O.K. for us.  Best Wishes, MATT P.S. --- Stephanie Wiles sez we need to connect re: eMuseum, Lucille!  I’m sure I could use your advice!  My first hurdle is getting some sign of life from Cornell’s central IT dept., which hosts TMS for us.  I guess they’re just too deep in the matrix to be bothered with me!

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Lucille Stiger
Sent: Wednesday, December 12, 2012 9:03 AM
To: [log in to unmask]
Subject: TMS Question: Which is better?

 

Hi,

 

The scenario is when you have an artist named John Doe. But you also have a work created by "Circle of John Doe" and "Workshop of John Doe."  What is the best way to handle this in terms of listing the artist in reports and label views:  create separate constituents for Circle of John Doe and Workshop of John Doe, put "Circle of" and "Workhop of" in the prefix field of the artist John Doe when applicable, or create additional roles for "Circle of" and "Workshop of" to be used in place of the role "artist."

 

Any guidance would be greatly appreciated.

 

Sincerely,

 

Lucille


Lucille Stiger
Registrar
Allen Memorial Art Museum
440.775.8668

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.




--
Lucille Stiger
Registrar
Allen Memorial Art Museum
440.775.8668
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.