I would like to put a script button on an edit form which would export a subset of fields in that record directly to another database. I can get it to write the data to a file but then I have to manually open the second database and import the file. Is it possible to automate the whole process within the one script so it would copy the required data, open the second database and import the record?
Regards
Margaret

I know of no way to do this using a script. However, the DB/Text PowerPack Importer is a service which will watch a specific directory and automatically import the files put into that directory into a textbase with the options you specify.

For the DB/Text product line, the DB/Text PowerPack Importer is part of a separate product: DB/Text PowerPack.

For the Content Server product line, the CS/Importer is included with the CS/TextWorks and CS/WebPublisher PRO software.

Instead of writing out the new record into a file, your script can open a new record set in the other textbase(application.newrecordset(textbasename, path, password), then newrecordset.Open(""), create a new record (.addnew) and place the entries, field by field into the new record.

Norma