I have a database with a telephone field. I have to export those
numbers and get the "scrubbed" by a do not call service and the
numbers will come back in txt format.

How do I check these numbers against my current database?

Basically I have to identify a given set of phone numbers in my
database that matches the txt file I'll have.

Any ideas?

P.S., I'm rookie at FMpro 7 with some minor scripting knowledge. Any
ideas would be appreciated.

Thanks,

Alfred

Renfer wrote:


FM won't operate on the text file. You need to have it in FM beofre
anything happens.

Create a DontCall table with one field (Phone). Import the text file into
it.

Create a relationship between the phone number fields in DontCall and
Existing.

In your Existing table, create a calculation field to tell you if the
there is, in fact, a relationship match, such as

Flag = [ If ( Existing::Phone = DontCall::Phone ; 1 ; 0 ) ]

Find and delete all of the entries in which Flag = 1.

Matt

Thank you Matt,

I'll do exactly this.

Much obliged...

Alfred

On Thu, 21 Jul 2005 22:39:05 GMT, "Matt Wills" <I'm (AT) Witz (DOT) end> wrote: