So I've got one field in an inventory database that lists the owner.
This changes over time, and it's useful to discover who had an item X years ago. We've asked people to put this into the Comments field, but with low percentage of success.
I believe I've seen an approach where you could take the existing contents of a field then place it in another field when it's modified. Ideally I'd like it to build the list automatically and have it not be editable by anyone except an admin.
Anyone have a simple yet elegant way to solve this?