Sue,

I have an update query for inserting conxrefs that could be reconfigured to insert a rights related link. You might want to see about grouping the 1000 by object package, and dealing with them carefully person by person. My update query is meant to run this way.

Sent from my iPhone

On May 30, 2012, at 1:13 PM, "Garton, Susan" <[log in to unmask]<mailto:[log in to unmask]>> wrote:

Hi all,

I’m wondering if anyone else had rights related constituents entered in TMS before upgrading to TMS 2010? We have over 1,000 of them entered as acquisition related constituents, with roles of Copyright Owner and Copyright Contact. We’d like to move them into Rights Related Constituent Xrefs on the R&R screen, and I’m wondering if anyone has already written a SQL update to do this. Thank you in advance for sharing if so!

Sue Garton
Data Administrator
National Portrait Gallery
(202) 633-8554 / [log in to unmask]<mailto:[log in to unmask]>

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.