Hi Margaret

I have written a view and related Crystal report that seems to work for me in getting all expected appraisers/valuers linked to an object. This can be run from the Objects module. You or your system admin people will need to execute this view in SQL (if you can't do this let me know and I can try to build the report using just existing tables/ views). Are you able to add a Crystal report to TMS?

I have run this report against a record selection, for instance an object package, and I have put in parameters where you need to select the appraiser name and valuation purpose from the drop down list.  Let me know if this doesn't get the data you were expecting.

Kind regards, Sally


Sally Fletcher
Senior Registrar
Australian National Maritime Museum
2 Murray Street
Darling Harbour
www.anmm.gov.au<http://www.anmm.gov.au/>

GPO Box 5131
Sydney NSW 2001 Australia
Phone +61 2 9298 3726
Mobile 0418 438 273
[cid:image001.jpg@01CD23A8.B0B3BE60]




From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Margaret Bullock
Sent: Wednesday, 25 April 2012 8:08 AM
To: [log in to unmask]
Subject: Finding constitutents linked to object value--Part II

Hi all,

I wrote last week having problems getting the Object Value query to work in the Objects Module to identify linked appraisers.

I tried the various work-arounds suggested (adding the Constituent ID, Last Name, Institution categories) to the Object Value search in DB Config  and still nothing. I've also tried clearing out the whole Object Value search and re-establishing it.  I get the same error message ("The multi-part identifier can't be bound") with all search variations  I try under Object Value (and I've tried a LOT) so it seems something is wrong with that query structure within our version of TMS.

Back to tech support! And thanks all for your ideas.

Margaret Bullock



Margaret Bullock | TACOMA ART MUSEUM
Curator of Collections and Special Exhibitions

T: 253.272.4258 x3019
1701 Pacific Avenue, Tacoma, Washington 98402
www.TacomaArtMuseum.org<http://www.tacomaartmuseum.org/>


THE SECRET IS OUT / AND YOU'RE INVITED
HIDE/SEEK: Difference and Desire in American Portraiture
March 17-June 10, 2012

To unsubscribe, send an email to [log in to unmask]<mailto:[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.

________________________________
This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited and may incur severe penalties. If you have received this transmission in error, please notify us immediately by telephone on 02 9298 3777 and delete all copies of this transmission together with any attachments.

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.