AnsweredAssumed Answered

Auto complete field from external file field

Question asked by QuantaCaV on Jan 25, 2013
Latest reply on Jan 25, 2013 by philmodjunk

Title

Auto complete field from external file field

Post

     Hi, 

     I have two databases...

     TREE INFO                                                                                                    SITE DATA

     (A database of trees and the species related info i.e. textbook)           Site tree survey (site data record by me of individual trees)

     - Botanical name                                                                                               - Botanical name

     - Common name                                                                                               - Common name

     - Mature height                                                                                                  - Dimensions (of a specific tree)

     - Colour                                                                                                              - Location

     - etc                                                                                                                      - etc

      

     When I am filling out the SITE DATA file, I have "Auto complete using existing values" turned on.  I still have to type in the Botanical name and common name at least once before this becomes a benefit. 

     How do I link the Botanical and Common name fields in the SITE DATA file to the Botanical and Common name fields in the TREE INFO file, so that, when I type the first letter of a tree, lets say "E" into SITE DATA, all of the Botanical name records from TREE INFO are displayed to choose from?

     Secondly, from reading through the help and forums, I see now that filemaker can automatically select the Common name when I as a user choose a Botanical name.  Would this be able to continue across files in the manner above?  

     One issue I can see is that the two databases don't have an inherent common field. 

     Thanks

      

Outcomes