Marie-Élaine,

 

You could search in the Text Entries table in SQL, using the ConstituentID.

 

Best,

 

Sue

 

 

Sue Garton

Data administrator

Smithsonian

National Portrait Gallery

 

[log in to unmask]  |  202.633.8554

 

 

Hello,

 

I would like to delete a constituent but I can’t because it has been inserted somewhere in the text entries.

 

 

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

	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.org               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é | Se désabonner | Inscription à l'INFO-MUSÉES

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.