Inputting Duplicate Data

I'm attempting to build a customer data base on office 2002.
I want to be able to see if that customer has any previous records while im
inserting their info (similar to an autotype feature when in word or excel).
Is there a filter or a template that allows this?
Thanks,
Conrod.

Build it in what?

"BadBoyCon" <BadBoyCon@discussions.microsoft.com> wrote in message
news:FDBFA0D2-7D44-4318-9C79-B050954132B2@microsoft.com...
> I'm attempting to build a customer data base on office 2002.
> I want to be able to see if that customer has any previous records while
> im
> inserting their info (similar to an autotype feature when in word or
> excel).
> Is there a filter or a template that allows this?
> Thanks,
> Conrod.

If the data base is an Access database, simply set the field to "Indexed
No Duplicates" in the design.

BadBoyCon wrote:

> I'm attempting to build a customer data base on office 2002.
> I want to be able to see if that customer has any previous records while im
> inserting their info (similar to an autotype feature when in word or excel).
> Is there a filter or a template that allows this?
> Thanks,
> Conrod.