Global variables do not work across multiple files - never did... but global fields do. You just need a table occurrence in each file for the table that contains the global fields. You don't even need relationships to get to global fields.
Variables are only accessible in the file where they are created.
Copying data to the clipboard should work but it is not the best option
1) Add an external data source to your target table from your target file to your source file. Add a table occurrence based on that target table to your source file. Now you can modify data in your target table without changing files and a Variable now works.
2) Add a script to your target file that modifies your target table. Use perform script in your source file to perfom the script in your target file. Pass the data that you want to send to your target table as a script parameter.
Tried alternative 2): I used a Global-Text-Field in the Source-File; used a Perform-Script that called a script in the Target-File; but can not seem to get and set the data in the Global-Text-Field??
2) does not use a global field. It uses a script parameter.
Not familiar?? What is a "script parameter"?
OK---OK---I figured it out. For some reason I was brain blocked to adding the table in the RELATIONSHIP tab, thinking I needed a linking field. Thank you for your patience with me but your efforts did help.... -Jim H
you might look it up in help.
There's a box in the specify script dialog labeled "optional script parameter". This can be a literal value or a calculated expression. On the other side, get (ScriptParameter) retrieves the data passed in the script parameter.
Your parameter expression might be:
List ( sourceTable:;FieldA ; sourceTable::FieldB )
In the other script,
GetValue ( Get ( ScriptParameter ) ; 1 )
retrieves the first value, the data from FieldA in your source table.
If if any of these functions are unfamiliar, look them up in Help.