Auto complete field from external file field
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.