How can I use a script to take data from the first file, create two new records in a second file, and insert the data there?

How can I use a script to take data from the first file, create two new records in a second file, and insert the data there?

How can I use a script to take data from the first file, create two new records in a second file, and insert the data there?

The easiest way is to create a relationship between the two files and with this relationship bring the data into the second file. Create a serialized ID number for the first file, FirstFileID. Then in the second file create a new field also called FirstFileID. In the FirstFile, create a script that copies the FirstFileID then calls a script in the second file. The script in the second file with first paste the contents of the clipboard to FirstFileID. You can now use a relationship to move the data into the secondfile.

Few things to keep in mind, using this method you erase what is in the clipboard which may anger your users, you could use global in the first file with a 1:1 relationship in the the files to gain access to that gloabl eliminating need to use the clipboard. Also, why copy the data into the second file if you have access to it with this new relationship?

The easiest way is to create a relationship between the two files and with this relationship bring the data into the second file. Create a serialized ID number for the first file, FirstFileID. Then in the second file create a new field also called FirstFileID. In the FirstFile, create a script that copies the FirstFileID then calls a script in the second file. The script in the second file with first paste the contents of the clipboard to FirstFileID. You can now use a relationship to move the data into the secondfile.

Few things to keep in mind, using this method you erase what is in the clipboard which may anger your users, you could use global in the first file with a 1:1 relationship in the the files to gain access to that gloabl eliminating need to use the clipboard. Also, why copy the data into the second file if you have access to it with this new relationship?

The easiest way is to create a relationship between the two files and with this relationship bring the data into the second file. Create a serialized ID number for the first file, FirstFileID. Then in the second file create a new field also called FirstFileID. In the FirstFile, create a script that copies the FirstFileID then calls a script in the second file. The script in the second file with first paste the contents of the clipboard to FirstFileID. You can now use a relationship to move the data into the secondfile.

Few things to keep in mind, using this method you erase what is in the clipboard which may anger your users, you could use global in the first file with a 1:1 relationship in the the files to gain access to that gloabl eliminating need to use the clipboard. Also, why copy the data into the second file if you have access to it with this new relationship?

Alitheg, If you really do need to create a separate file, try export from your prime file and then 2 x import (via external script) in your secondary file.

If you are not copying the records exactly, then just export/import a key and look up what you need.

Alitheg, If you really do need to create a separate file, try export from your prime file and then 2 x import (via external script) in your secondary file.

If you are not copying the records exactly, then just export/import a key and look up what you need.

Alitheg, If you really do need to create a separate file, try export from your prime file and then 2 x import (via external script) in your secondary file.

If you are not copying the records exactly, then just export/import a key and look up what you need.