Hi SteveB

No, they use seperate tables with common fields.

Hi All,

Thanks for all the responses so far. The secondary BD is actually a CRM system. they will use info from it for all correspondence with their customers. So what...

Hi All,

Apologies for sending the sample data in the format as in my previous post. will send a proper one.

Hi All,

Thanks for all the responses. Here is a sample of my DB:

Fullname, ID_no, Modifiedon, Membershipno,Adress1, Address2, Postal Code

Joe Soap, 123, 2008-09-04, 001, 1 sloane str, Hampton, ,

Joe Soap,...

I tried both but ended up using NOT EXISTS because like you it perfomed better for me. I think its always best to use it.

Hi all,

It worked, thanks.

Hi Adi,

You are right, this worked like a charm, thanks.

P.