I have a table with computers and their users. When the computer breaks I need to swap it for a working one.
I use a barcode label as the key for my computers table.
When swapping out the computer I just want to delete about 4 fields of User information on the broken machine’s record and then add that information to the replacement computer’s record.
I would think an Update Query that could copy the fields to the new machine and delete them from the old machine would be the best way to do this but unfortunately I don’t really see many examples to exchange information between records in the same table.
While just changing 1 record sounds trivial this happens anywhere from 10 - 30 times a day so automating the swap would be helpful.
Maybe better to use SQL?
I use a barcode label as the key for my computers table.
When swapping out the computer I just want to delete about 4 fields of User information on the broken machine’s record and then add that information to the replacement computer’s record.
I would think an Update Query that could copy the fields to the new machine and delete them from the old machine would be the best way to do this but unfortunately I don’t really see many examples to exchange information between records in the same table.
While just changing 1 record sounds trivial this happens anywhere from 10 - 30 times a day so automating the swap would be helpful.
Maybe better to use SQL?