Script connecting two databases
I have inherited a set of Filemaker Pro 8 databases and am trying to figure out how to better automate them without a total overhaul. There's one database which receives student registration information from a web form (student name, address, etc.). Then, there's another database where this registration information needs to be entered into several tables (this is currently done by hand). I'd like to create a button on the first database which, if clicked, will transfer some of the data for a single record to a similar table in the second database. Is this possible? How would I do this? I have written a few basic scripts with loops and such but am not really familiar with all of the commands available, and I am not familiar with how to write a script which connects two unconnected databases.