Inserting info from a different database

[jjosh12]

How can I write a script that will, when I click a certain button that is the last field in the record it will copy all the information in the record insert it into the beginning of a new different database file delete the old database record that was copied and the new placement of the information copied not be modifiable, allowing me to carry on with the new database file input and showing me all the information from the copied database and not be able to modify the copied file once it is inserted into the beginning of the new database file of a different type.

Is this possible?

Any input would be greatly appreciated

Josh

[Ugo DI LUCA]

This cript will :

Show All records

Omit Record

Show Omitted (to make sure there is only this record selected)

....

External script (from the other file)

Import Records(Mainfile, no dialog*)

....

Delete record

Show All Records

*You need to make it once and keep the settings for all other imports to be made.

But...BACKUP YOUR FILES FIRST.

Then set all fields in the new Imported file to be controlled by calculations to prevent any modification.

[danjacoby]

A better idea:

Do it all in one database.

Create a global field for each data entry field.

Have the button:

Create a new record

Use the "SetField" command to set each field to the corresponding global field.

Clear all the global fields (I'd use "SetField" again).

Then disallow entry into all other fields, so people can only enter data into the global fields.

I'd put the global fields into a separate layout, with a button that takes folks to that layout to create a new record.