How to keep data?
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.