Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Should I write a script? (correcting related DB)


Recommended Posts

I have the task of correcting data in a related table--

In Contacts, I have fields OldID and NewID. My Donations

table is linked to the Contacts table via

Donations:ContactID Contacts::OldID. Now I want to

achieve the following:


For each record in Contacts,

- Use oldID to find the related record in Donations,

- Update Donations:ContactID to Contacts:NewID"


In SQL i'd do an update query, but dont know how to do it in



Any help would be appreciated, thanks in advance!




[ ikamanu@gmail.com ]

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use