FileMaker Pro help

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by David Morrison Tue, 12 Jan 1993 02:59

#615

Author: David Morrison
Date: Tue, 12 Jan 1993 02:59

18 lines
1066 bytes

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 ?


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.

Thank you...

David
email : s914370@minyos.xx.rmit.oz.au

Re: FileMaker Pro help

#622

Author: Nick B Triantos
Date: Tue, 12 Jan 1993 15:35

30 lines
2222 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads