RE: scripting copy from one filemaker database to another
RE: scripting copy from one filemaker database to another
- Subject: RE: scripting copy from one filemaker database to another
- From: David Graham <email@hidden>
- Date: Wed, 24 Jan 2001 16:05:47 -0800
At 6:43 AM +0000 1/24/01, Pitcher, George wrote:
Surely you ca do all of this without Applescript. The script steps are all
rthere in FMPro to allow you do do it along the lines of:
Script in DB1>>>
Copy [sourcefield]
perform Script(External) [database2.newrec]
Script in DB2>>>
New Record/Request
Paste [field]
Using Scriptmaker over AppleScript will save you time and headaches
when working with FM (assuming you can achieve the same effect).
There's actually a better way to do this type of thing though ...
Create calculation fields in both files with a result of 1 (must be
stored & indexed) and make a relationship between the two files based
on these fields. Make the relationship name "constant".
Now all you need is a script step that looks like this:
Set field [ "constant::field1", "field1" ]
Set field [ "constant::field2", "field2" ]
It's much faster, doesn't use the clipboard, and only requires one
script. Once you start using constant relationships you'll wonder how
you ever got by without them .
- Dave
--
==============================================================
David Graham Partnerships With Industry
MIS Manager 7540 Metropolitan Dr., #105
voice : 619.681.1999 San Diego, CA 92108
fax : 619.681.1990
http://www.pwiworks.org
AOL IM: dmgraham22
mailto:email@hidden
"We assist persons with disabilities to work in the community"
==============================================================