I want to print Letter No. 1 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 1 Sent, today's date."

Later, I want to print Letter No. 2 to a batch of clients. I want the script to leave a message in LETTERS SENT field on each record, "Letter No. 2 Sent, today's date."

I want the messages to accumulate so I will have a record of all letters sent to each client.

I always appreciate your assistance. Maxwell Morlay

In the script, as you're looping through the records to print, use the Set Field step put the text you want with the date appended by Status ( CurrentDate ). You could use the same field and overwrite the information or use a different field each time you send a letter. Or you could use a repeating field, specifying the repetition in the Set Field step.

If you plan on this being a large or long-term kind of solution, I would recommend breaking the notifications out into a separate table. While appending the text onto the end of a text field achieves a result of storing this data, it's not really usable there. Instead, create a Messages table, with this structure:

ID - Unique ID (Either a serial number, or, better, see CaptKurt's suggestions)

Date

ClientID

MessageText

Then instead of adding to the text field, create a new record in this messages table.

With this structure, you will be able to search for Messages in a broader number of ways--most importantly by Date.

HTH.

David