2 Replies Latest reply on Jul 4, 2014 8:45 AM by BenLuu

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

    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