| Validation(Duplicate checking) [message #301891] |
Fri, 22 February 2008 03:10  |
manojvilayil
Messages: 6
Registered: November 2006
Location: Kochi
|
Junior Member |
|
|
Suppose I have 2 tables
DATA_BANK(candidate_id,name,phone,address)-Master
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
