AnsweredAssumed Answered

Validate value in one field according to value on the other field

Question asked by BenLuu on Jul 4, 2014
Latest reply on Jul 4, 2014 by BenLuu

Title

Validate value in one field according to value on the other field

Post

     Hi every one ! 

     I Just new to FM Pro, currently I just have project to create the Help Desk Database for ICT Department. In this Database I ve created a Table called "Ticket Details",this table has two field called:"TicketStatus" and "JobStatus". The "TicketStatus" has value list which has 3 values:"Pending","Not Resolved" and "Completed". The "JobStatus" has 2 values :"Not Done" and "Done".

     I just want to prevent and give the User warning when they try to close the Ticket by click on "Completed" in "TicketStatus" while other fileld "JobStatus" still "Not Done". I stuck on this for a few days and couldn't figure it out how to do this, I would highly appreciate if some one can help me on this.

     Thank you .  

     Ben Luu

Outcomes