Duplicates

[Dazzle]

Hi guys,

How can i get the database to automatically check for duplicates as i'm inputting data?

I just want it to stop me after i've put in the company name and tell me that there is already a client under that name.

Thanks
Daz

 

[maxmangion]

you can do that using the dlookup function. if you search this forum for that function you will find plenty examples.

 

[coyote]

This should help

http://databasedev.co.uk/duplicates.html

Cheers