Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Inserting info from a different database


This topic is 7851 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7851 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.