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.