Maintaining history file

[SandyJ]

I have an inventory database in FMPro 5 and want to keep a history of who checks out various pieces of equipment. What I would like to do is to keep the current checkout information in the file, but write the checkout history to another file or field. I haven't a clue about how to go about this.

I'm obviously new at FM but I thought I did well in creating a Checkout Report using a button that performs a find script.