Hello, I am sure this is a simple problem but I am stuck on it. I am building a database to keep record and generate work orders for a device. However, sometimes we already have the device in house which was returned from an account and we reissue it to a new one.
What I am getting stuck on is how do I set up a table the keeps track of this transaction along with adding cost, etc. And make sure that the device is linked to the new account via the work order.
Any and all help is appreciated!