Can anyone help?

In my database, I want to be able to make an entry into one field, have the same data copied into a different field in a different layout, but have the data entered one record before the original entry.

The Gobblers

The trick is how you define "one record before" Do you mean the original unsorted order of record creation, or dynamically based on the current sort order for that layout?

Dynamically based on the sort order for that record I think.

eg if I add a record in layout (a) record number 3 I want go to layout ( and make that entry appear in its new field but in record number 2

Hi, the easiest way to accomplish this is using a script which is activated with a button. Create a new global text field, I'll call it gStorage. The script can be something like the following

Set Field [ gStorage; YourSourceField ]

Go to Record/Request/Page [ Previous ]

Set Field [ YourTargetField; gStorage ]

Go to Layout ["WhereverYouWantToGo"]

Regards,

Peter