🚀 go-pugleaf

In article <1itc70INNo2d@escargot.xx.rmit.OZ.AU> s914370@minyos.xx.rmit.OZ.AU (David Morrison) writes:

>Help needed with FileMaker Pro!

>Using the ScriptMaker (under v2.0) I am trying to pass some information
>from one file to another. This I use Copy / Paste. However, I need to be
>able to hold two pieces of information in the clipboard at once. Is this
>possible ?

Well, what you can do is to concatenate both fields into one text
calculation and separate them by something obvious, like this:
  MyTextCalc = Field1 & ":::" & Field2  , result is Text.
You can then search for ":::" with the Position() function and parse your
two original fields back into two fields with the Let() and Right() functions.

>Am I correct is assuming that FileMaker Pro cannot implement properly a 
>many-to-many relation (as in a true relational data base). I know you can
>look at info. in another file by using the Lookup feature, but can you
>transfer information from a particular record to another record (different
>type - in a different file) to create a new record of this type.

Unfortunately, you are right.  FileMaker Pro is still just an extremely
powerful FLAT FILE database, with hints of relational capability through the
lookups and external scripts.  Again, this is something on my own personal
wish list of future FileMaker Pro changes...

Nick Triantos                     Avoid bus errors... Take the train!

Though I work for Claris in Technical Support, the thoughts, words, and
suggestions expressed here are NOT officially endorsed by Claris in any way