Update records from secondary table

[SoomoTom]

Hi all,

I'm new at this stuff, please forgive my ignorance!

I have a email db with contact information for a group of people.

I have a spreadsheet with 50 names who want to opt out.

My main list of people is table 1 (T1)

I was thinking of importing the spreadsheet into a table (T2).

Run a script that would open the first record in T2 and look for the matching email address in T1.

If found, update the record in T1 by adding 'opt-out' in the comment field.

Loop back to record 2 in T2

Is my logic good? (I may be way off on how to accomplish this)

How do I begin?

Thanks very much,

Tom

[mr_vodka]

If you create a relationship between the tables based on email, you could use a go to related records [ match found set ] to T1, and then if there are found records, then you can replace field contents those records with "opt-out".

Make sure you error trap properly and be careful with replace field contents as it can not be undone.