Validate value in one field according to value on the other field
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 .