Marie-Élaine, You could search in the Text Entries table in SQL, using the ConstituentID. Best, Sue [cid:image001.png@01D16E4E.942FCC80]<http://npg.si.edu/> Sue Garton Data administrator Smithsonian National Portrait Gallery [log in to unmask]<mailto:[log in to unmask]> | 202.633.8554 From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Mathieu, Marie Élaine Sent: Monday, January 16, 2017 12:01 PM To: [log in to unmask] Subject: Search in the Text Entries fields Hello, I would like to delete a constituent but I can't because it has been inserted somewhere in the text entries. [cid:image002.jpg@01D27012.4A0B9140] As there are Text Entries everywhere in TMS, does anyone know if it is possible to perform a query in all the Text Entries fields at the same time? Thank you, Marie-Élaine Mathieu [Musées de la civilisation]<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=logo> Marie-Élaine Mathieu - T. 418 643-2158, poste 825 Bibliotechnicienne Dir. des collections et des relations avec les musées québécois MUSÉES DE LA CIVILISATION 9, rue de la Vieille-Université, , Québec (QC) G1R 5K1 Canada mcq<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte>.<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte>org<https://www.mcq.org/fr/?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> [Google Maps] <https://mapsengine.google.com/map/viewer?mid=zIyJ1odA15Zs.kcPuns8EA06k> [Facebook] <https://www.facebook.com/mcqorg> [Twitter] <https://twitter.com/mcqorg> [Flickr] <http://www.flickr.com/photos/museedelacivilisation/> [Youtube] <http://www.youtube.com/mcqpromo> [cid:image009.png@01D27012.4A0B9140]<https://www.mcq.org/fr/exposition?id=408001&utm_medium=courriel&utm_source=mcq&utm_campaign=signature-outlook&utm_term=25xlarevolte&utm_content=banniere> Avis : Ce message est confidentiel et ne s'adresse qu'aux destinataires. Si vous le recevez par erreur, veuillez le supprimer et nous en aviser. Politique de confidentialité<https://www.mcq.org/fr/politique-de-confidentialite?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> | Se<https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> <https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> désabonner<https://www.mcq.org/fr/emarketing/desabonnement?utm_source=mcq&utm_medium=courriel&utm_campaign=signature-outlook&utm_content=texte> | Inscription à l'INFO-MUSÉES<https://www.mcq.org/fr/info-musee> 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.