sorry, but i don't know what to call what i'm trying to do.

i have a text field, into which go notes, updates, etc, that change from time to time. i would like to keep a record of the change, but i don't want to have to scroll down to the bottom of the box every time i enter something.

right now, the field is formatted as text, and data entry goes something like this:

first entry 9/1/03:

available fridays and saturdays

second entry 9/5/03:

will be out of town from 9/6/03-10/6/03

third entry 10/7/03:

back in town, available tuesdays and wednesdays.

i would like the final field to look like this:

back in town, available tuesdays and wednesdays.

will be out of town from 9/6/03-10/6/03

available fridays and saturdays

so that the first entries are at the bottom, and the new ones are at the top. kind of like when a portal/relationship's sort order is descending.

aside from funny data entry (manilpulating the text as it is entered, is there a way to do this?

i'm open to "archiving" the changes to another field, perhaps one that has all the old changes, and then the current field only shows the current change.

any ideas?

thanks in advace.

josh

Hi--

you could try using a separate field for the new entry ( maybe a global, lets call it zg_NewEntry, result of text)

Then you create a script that you attach to a button

If (IsEmpty (zg_NewEntry)

Exit Script

End If

Set Field [ Your notes field, zg_NewEntry & ":PP" & Your notes field ]

Set Field [zg_NewEntry, "" ]

Exit Record/Request

Where :PP is the carriage return symbol.

This should place your new text at the top of the field with the existing notes field contents below.