Supriya

• May 31st, 2006

 

We can find duplicate record by using 'POST' builin in when_new item instance trigger at item level in detail block.

POST;

Writes data in the form to the database, but does not perform a database commit. It's temporary commit thats useful for duplicate validation. 

osden

• Oct 7th, 2007

 

Create a trigger at form level When-database-trigger Post;  (this
command will temporary apply the changes to the database) Than you find by Sql
Query if it is duplicate Record.

madhav_menti

 Profile Answers by madhav_menti 

• Apr 4th, 2008

 

In this senario Better to  use record group. Using record group we dump the table data at client system level and check the entered data. To achive this you write functions to find dup record under the Trigger When_new_item_instance at the block level. If any body wants complete code please mail me.