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.