Home » Developer & Programmer » Forms » Validation(Duplicate checking)
Validation(Duplicate checking) [message #301891] Fri, 22 February 2008 03:10 Go to next message
Messages: 6
Registered: November 2006
Location: Kochi
Junior Member

Suppose I have 2 tables

QUALIFICATION(candidate_id,qualification_id,university,year of pass)-Detail

In form i want to impliment a validation
The idea is when i enter a new candidate it checks whether any other candidate with corresponding master detail exist.If then checks any details exist.If a change is tracked then new candidate is saved,other wise not saved.

In which trigger i perform this validation

Please reply immediatly

Thanks in advance
Re: Validation(Duplicate checking) [message #301897 is a reply to message #301891] Fri, 22 February 2008 03:35 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-VALIDATE-ITEM (or WHEN-VALIDATE-RECORD; see which one of these better suits your needs).
Previous Topic: Maximum number of columns in LOV
Next Topic: frm-92101 There was failure in forms server during startup
Goto Forum:

Current Time: Mon Aug 21 01:24:37 CDT 2017

Total time taken to generate the page: 0.00890 seconds