Re: Duplicate value in a column

Try record validation. You should be able to place the same logic in when-validate-record trigger. This trigger does fire when you navigate from one record to the other, even thro a mouse. Loop thro' all records in the multi-record block - checking for the record status and the column values.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.


venkatj_at_finance3.corp.sgi.com (Venkatesh Jagadeeshwara) wrote:


>How can I restrict a user by entering duplicate values

>in a column (multirow block)?

>Check has to be done before commiting.

>

>I had handled this in Forms 3.0 by using a procedure in

>which I scan thru the entire block.Since Forms 4.0 supports

>mouse the same technique is not working.Thanks in advance.

>

>Venkat