Should I write a script? (correcting related DB)

[ekz]

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

FMaker!

 

Any help would be appreciated, thanks in advance!

 

-ekz

 

[ ikamanu@gmail.com ]

[Maarten Witberg]

see answer here

 

please do not double post.

 

kjoe