Multi field entry

[thegobblers]

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

[Reed]

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?

[thegobblers]

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

[PeterHW]

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