need duplicate check when adding record

[marlun]

Hi. I have a big problem, and I would appreciate any help I can get.

I have a form that adds records to the db. I have a primarykey called ProdSN (here are two examples of how the ProdSN can lokk like: 4-700-1.0250009, BLM42002). When you have typed a new ProdSN in its textbox and on "Lost focus" I want it to check for ProdSN:s in its table that are similar (duplicates). If I write a ProdSN that already exists I want it to ask me to write in a new ProdSN. And if there aren't any similar ProdSN:s in the table I want to continue filling out the form.

Hope somebody out there understands the problem that I have.

Many thanks

/marlun

 

[ajdesalvo]

Please do not cross-post. I have posted a reply in your other thread thread702-479371.

Cross-posting will probably deter people from assisting you.

Thanks in advance!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[marlun]

Thanks for your help. Sorry about the cross-posting. Wont happen again.

Thanks

 

[ajdesalvo]

You are always welcome, hope I can be of help again in the future!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"