Finding the same data in two different tables.

[Mattg-zzz]

One table has all my clients and the another table has all the calls I have made. I would like to preform a find that would show me all the clients that I have not called yet.

[LaRetta]

Hi Mattg-zzz,

You haven't indicated whether these tables are currently related on ClientID. If not, you can relate them on phone number? Client:Number = Phone:Number. You may wish to use Filter on both sides to produce an exact match if the phone numbers aren't normalized.

Then create a calculation (number) with:

IsEmpty(Phone::Number)

Script to Find uncalled Clients:

Perform Find [Restore ... enter a 1 in your specify find box ]

If the tables are currently related on ClientID, just use IsEmpty(Phone::ClientID)

LaRetta

[Mattg-zzz]

LaRetta, They are related by a CustId field. Can I still do a Customer:Number=Phone:Number & what type of fliter are you thinking of?

thanks

[LaRetta]

If they both contain the ClientID, that would be best to use; saves creating additional fields. But you can relate on phone number. You would create your Number keys as:

Phone Number = Filter(Number; "0123456789")

Then relate on that. This strips any '-' or "()", etc. which might differ between the two sets.

Then just Perform Find on the above calculation, storing a 1 in the Find Request.

[Mattg-zzz]

Great, thank you. It was much easier then I thought.