I would like to auto-enter 30 to 40 lines of data into a field. This data would include field definitions from the same file (table) that the field is located in. I do not know how to do this or if it is possible. Thanks in advance for any thoughts.........Ray

Edited February 14, 200620 yr by Guest

Perform applescript:

set tablename to "Invoices" -- change to suit

set targetField to "Table Definition" -- change to suit

set fdefault to current application

copy formula of every field of table tablename of database 1 to f

copy name of every field of table tablename of database 1 to n

set temp to ""

repeat with num from 1 to count of n

copy item num of f to f1

copy item num of n to n1

if f1 = fdefault then copy "" to f1

set temp to temp & return & n1 & return & f1 & return

end repeat

copy temp to cell targetField of current record

Hi BruceR, is this a response to my original post, if so, I am at a loss to understand it.

Thanks, Ray

Thought I would try to clarify my question. I would like to enter a "fixed text message" using the Auto-Enter option for a field. Within this fixed text message would be a few fields from the same file. There is probably many other ways to do this which I am unaware of.

This field is used when I generate a mass email.

Thanks, Ray