Duplicating records from a db

[pes]

Someone in our school district has created two separate dbs with the same fields. When she creates a record in one database, she wants it to automatically create the same record in the second database. I suspect that this requires a script. Can someone offer some advice, please?

[jenniweiss]

This seems like a very odd thing to want to do. I first strongly suggest that you think about whether you really need duplicate databases.

If you really want to do this, one possible method is to write a script to import the new record into the second database. To do this, you will have to make the new record the only one in the found set, use a flag field and automate the find. Define an import script in the second database and a script in the primary database that calls the import script as an external one.