I too have bemoaned the Exhibitions module for its seeming unsuitability for planning exhibitions (which requires a lot of manipulation of data, rather than simply recording it). But yes, we keep returning to the same answer: if you have the time to invest in a lot of learning, you can eventually make the system work. I continue to feel that it is a huge shortfall of this software that so much of the burden of skill falls to the user. Laurie Hicks High Museum of Art -----Original Message----- From: David Parsell [mailto:[log in to unmask]] Sent: Friday, December 06, 2002 2:12 PM To: [log in to unmask] Subject: Re: Sorting Object and Loan records within the Exhibitions Module If you write reports in Crystal Reports, you can sort TMS data almost any way you choose. Also, CR saves the messy work of exporting and manipulating the data in excel since you can easily review the report on screen after you query the appropriate data. CR is extremely powerful. I rarely have the need to export TMS data for manipulation in another program. However, CR does require a commitment, especially to learning how the TMS tables are linked. I suggest taking the Gallery Systems CR class to learn TMS table linking and CR. David Parsell Yale University Art Gallery At 05:25 PM 12/6/2002 +0000, Jonathan Thristan wrote: >Hello TMS Users! > >At Tate we use TMS to record details of all of our Displays and >Exhibitions. Curators and Registrars both agree that the inability to >specify sort orders (via a drop down?) for the lists of Object and Loans >within the Exhibitions module is a major drawback of the system. It >tends to mean that users view exhibitions information via reports (e.g. >for exhibitions a report exported into excel, sorted according to need), >rather than via standard forms. Unfortunately, at Tate it has also made >some members of staff reluctant to use the system. Has anybody else >encountered this issue? Any thoughts? > >Regards > >Jon > > >Jon Thristan >Tate >Systems Manager >E: [log in to unmask]