Duplicate prompt

[shijuantony2002]

Hello,

I know this might be a common question which you'll might had faced but still i had to query too as i am clueless on how to go about in finding a duplicate for an Input form.

Had attached the db for your reference.

I want the form to prompt message if the combination of multiple fields are similar for the previous records in the table.

Thanks for your advise.

 

[HiTechCoach]

... if the combination of multiple fields are similar for the previous records in the table ...

How close to exact match is similar? You may need to use "Fuzzy Logic" to get Close but not exact. I use a SoundEx function to get a "fuzzy" (similar) match.

 

[shijuantony2002]

well i meant exact instead.

fuzzy logiz sounds new to me. can you post an example?