Windows 7 64bit 
Access 2013
Didn't know how to search this one first...
So here is my scenario. I have a database that is set up to keep track of all devices (serial number, model, device name) in one table and all employees in another table. There is a middleman table, I guess you could call it that helps the database understand which devices are assigned to which employee. Currently I have it set up where you can assign a device to an employee on a form, save it and it will show up in the query when it is run. Only problem is that one device eventually will have more than one owner according to the database, which technically is false. My company purchases one computer per employee. Sometimes employees get upgrades or whatnot.
Here is what I would like to do:
When assigning a device to an employee, I would like to have a dialog box pop up to confirm this before saving the changes (that's the easy part).
After accepting the change I would like the device to remain only assigned to one person, which would be the new owner and not the previous owner.
If possible, I would also like to be able to track the history of who has been assigned to a device for future references.
Reply With Quote
