Keep a "history" of a field in a related portal

[Kristen]

This is similar to a previous post, but I still have not made much progress.

I have a field called SignInDeposit. This deposit amount changes as often as weekly depending upon the customer, and I would like to keep a "history" of the deposit amounts, shown in a related portal. Currently a new line item in the portal is created via a script that sets the current time, date, and user, and goes to a text field to allow the user to enter a "note". Is there anyway for me to incorporate something into this script and attach it to the fild called SignInDeposit or something I can do to keep this sort of "history"? Any thoughts??

THANK YOU

[stanley]

Kristen:

It sounds to me like you ought to be creating a new record for each of these deposits. It would be a separate file, and all it would contain is: deposit amount, date, time, user. Relate it to your main file via the user field (or a modified user field, to insure each user is actually unique), create a portal pointing to the new file, and viola, you've got your history of deposit amounts.

-Stanley