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: 21122
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: Not getting the FRM- 40200 Message
Next Topic: Form Close Event
Goto Forum:

Current Time: Thu Jun 22 15:39:01 CDT 2017

Total time taken to generate the page: 0.13792 seconds