1
0
-1

Hello experts.

So I have a form for staff to register their computer and one staff is only allowed one computer. I used Duplicate Value Validator for their staff ID to make sure there is no data redundancy. But now I want to create an option which admin will choose whether the computer is in use or has been disposed of. So I need to make a select box for the status of the computer. My problem is I still want to keep the data but staff cannot register their new asset because their ID is already registered. I was thinking to make another form where admin will have to manually transfer the data and then delete it from the main form. That way, admin can view the history of user's asset. I would like to ask if anyone can give a better solution? Thank you in advanced.

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi,

      The better solution is to build custom validator that will check for two things:

      1. Duplicate Value
      2. Status of existing computer.

      if both the cases are fulfilled then it won't allow to register again.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        But now I want to create an option which admin will choose whether the computer is in use or has been disposed of. So I need to make a select box for the status of the computer.

        Good idea! At the record row, introduce a status field to keep value like "Active", "Disposed ".

         

          CommentAdd your comment...