I need a script that copies the text from a field into a field in a related table! In other words, it copies the result from a field in table 1, opens table 2 and pastes that result into the specified field - Any ideas? I don't think you could transfer data this way in fmp 6, but I think i heard talk that you can in fmp 7?

Any suggestions would be great!

Thanks, Sarah

There are a few different ways of doing this.

One of the older ways is to use a global field to temporarily hold the data. You just use the Set Field script step to set the global to what you want, then switch to the the other table and use Set Field to move the data from the global to the record.

The other thing is that you can now use Script Parameters to do this. It's particularly useful if you are running the script from a button or calling it from another script using the Perform Script script step. You just set what information/calculation you want to use in the Optional Script Parameter box at the bottom of the Specify Script Options dialogue to choose the script. You can then call up the information using Get(ScriptParameter) in a Set Field calculation.

Does this help?

thanks!

Sarah