Try setting up a script that is specified in File Options to hide all previous records. Performing a find for a negative value in a serial number field, for example, can pull up an empty found set so that the fields are all blank until the user clicks a button to create a new record and start the registration process.
The above solution is working excellent. I appreciate for this help.
I need to transfer the whole updated database values from my server to some other server where a copy of this database is already available.
Is there any procedure or script by which it will be done automatically at certain time gap, like 'auto save' or something?
Please help me.
We routinely move all of our Purchase Order Records (We buy scrap metal and redeem used beverage containers from the public) to an Archive file on a nightly basis. Sounds like it could serve as a model for what you want to do here.
Define an import records script in the file of the file that will receive your imported records (the target file). Then use a script in the file that will send the records (the source file) to find all the records you want to send to the target file then uses Perform Script to perform the import script in the target file to import this found set from the source file into the target.
How you schedule this to take place on a regular basis can be a bit tricky. A server scheduled script cannot perform this script as server scheduled scripts cannot import data from another FileMaker file.
You can use Install OnTimer script to set a specific timer for exporting the data.
You can set this up in a script that runs each time the file is opened or each time that it is closed.
You can use a system scheduler such as Windows Task Manager to "run" a FileMaker "robot file" that performs this script each time it is opened.