This discussion is archived
4 Replies Latest reply: Dec 27, 2012 6:13 AM by only.ashish99 RSS

When validate trigger forms 6i

only.ashish99 Newbie
Currently Being Moderated
Please help me to create when validate item trigger.

There is one table "job" - id, status

status is X or null. i want to do in forms. when someone is entering value for id, it should check first the status for that id in job table status field.

if status is null then it should show msg "this id is already open for another job"

Edited by: only.ashish99 on Dec 26, 2012 1:44 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points