I am trying to recreate a portion of a database for my company. I am currently using a database where you can enter notes into one notes field and press a save button, which will take the notes from the 1st field and enter it into a non-editable notes area and will also place a date / timestamp / username in front of the notes.

The user can also put a check mark in a box to have that same note entered into a main notes area for a client. If this option is checked, it will place the note in a main notes area and will also include the name of the creditor the note is specific to.

I am looking for help or input on the best way to re-create this type of process and fields/functions.

I have created a video and posted it on youtube to show you what I am trying to replicate.

Any help or input would be greatly appreciated.

Thank you all for your help.

Jason Oswald Jason(at)nationaldc(dot)com

Hello Jason,

To append data to a field you simply set the field to its existing contents plus the data that you wish to append. To prepend, set the field to the new data and the field.

In code:

Set field (myField; myField & "¶" & Get (TimeStamp) & someField

However, I usually find these monster textboxes of data a bad thing in the long run. They are impossible to report from. How about investigating the use of portals of notes. Each note is a record in a note table and has the foreign key of the parent record. (See demo)

PS: You can gather all notes into a calc text field using the List( ).

NotePopup.fp7_2.zip

Edited December 11, 200916 yr by Guest