i know this a dumb question but using a script how can you set a field to the value that was in the last layout you visitied

eg i start at Layout one and field one=2

i click a button it will set field one =2 in a different layout

Use a global field as a holder for the value, switch layout and set the field with the global value. Something like this:

# sets the global with the value from field one in layout 1 with

Set Field [ global ; field one ]

# switch to the next layout with

Go to Layout [ layout2 ]

# set field one in the new layout with the value from global with

Set Field [ field one ; global ]

# optional - use Go To Layout again to switch back.

# if you don't want to see this happen begin with Freeze Window.

Hope this helps.

Instead of storing the data from the first layout in a global field, you can also pass the data through the optional script parameter.

For example, in your script...

Go to Layout 2

Set Field [ fieldone ; Get (ScriptParameter ) ]

Hi,

This is a related question: how can you do the same thing, but with related databases? I want to copy a field from the current record the user is entering into a field that is in another database.

eg-

enter data into tapes.fm7-field1

hit button to activate script that switches to titles.fm7 and creates new record in title.fm7.

copy tapes.fm7-field1 into titles.fm7-field1

Sorry if dumb, still trying to get my head around filemaker. Thanks.

Simliar approach. Create a relationship between the two files. Use a global field or try a parameter open the file, add record, set field.