I'm new to filemaker and need to make a script which sends records from one database to another (they are identical in format). Does anyone know how to do this?

What do you mean by "sends records from one database to another". Do you mean copying the data from one file to the other? If so, why do you have two indentical files?

If they are both FileMaker, you can import one into another.

Lee

well, importing would work but I don't know how to import just one record. the import function only gives me the ability to import all records.

We have two databases, one which stores current employees, and one which stores former employees. I basically want to export drivers from current to former if they quit, are fired, etc. We used to have a script that did this until someone deleted our most recent copy of filemaker... I would use "export" or "import" but that only chooses all records. I just want to import/export certain ones.

Import with the files open. The one that has the information, you isolate a found set that matches what you want to import, and then go to the file that you want the data in and import.

Do a search of the Online Help (Help in the Main Menu with FileMaker open) for [color:blue] Importing data into an existing file, it's about half way down the page.

HTH

Lee

that makes sense. thank you so much!

Thank you for explaining. However, why not just have one file with a field that distiguishes who is current and who is a former employee?

Yes, The clue in your first post is that the data is identical...

You should consider combining the tables and displaying the results in a portal via a relationship.

That would make more sense, I agree. There are tons of scripts and reports that relate to our payroll system and this is the way that we do not print timesheets for former employees. You'd probably get sick if you saw the system we were using but nobody here seems to know much about Filemaker.