Hi Iris, Sorry for the late response - hope this might still be helpful. In Crystal, I use the select below to filter on current exhibitions. Hope it might give you some ideas. Best, Sue CurrentDate<CDate({vgsrpExhibitionsS_RO.EndISODate}) and CurrentDate>CDate({vgsrpExhibitionsS_RO.BeginISODate}) Susan Garton Collections Information Officer Smithsonian National Portrait Gallery [log in to unmask]<mailto:[log in to unmask]> | 202.633.8554 [cid:image001.png@01D8D720.6DB826A0] [Inline image 2]<https://www.facebook.com/npg.smithsonian/> [Inline image 3] <https://twitter.com/NPG> [Inline image 4] <https://www.instagram.com/smithsoniannpg/> [Inline image 5] <https://www.youtube.com/user/NatlPortraitGallery> npg.si.edu<http://npg.si.edu/> From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Blochel-Dittrich, Iris Sent: Sunday, September 25, 2022 10:28 AM To: ListServ tmsusers <[log in to unmask]> Subject: Prioritizing exhibition information External Email - Exercise Caution Dear colleagues, we have listviews, dataviews and reports in the object module of TMS collections where exhibition specific information has to be included. It's not always possible to go from the exhibition module as registrars and conservators will build object packages and work from there. As objects can have relations to many exhibitions I am wondering what might be the best way to define a primary exhibition. Has anyone ever worked eg with a combination of exhobjstatus and exhibition date? Best regards Iris Blochel-Dittrich museum documentation Stiftung Jüdisches Museum Berlin Lindenstrasse 9-14 10969 - Berlin Tel. : +49 30 25993-442 Fax. : +49 30 25933-409 **** Die neue Dauerausstellung **** Jüdische Geschichte und Gegenwart in Deutschland www.jmberlin.de/dauerausstellung<http://www.jmberlin.de/dauerausstellung> **** FÜR KINDER / FOR CHILDREN **** ANOHA - Die Kinderwelt des Jüdischen Museums Berlin www.anoha.de<http://www.anoha.de> 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. 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.