Lookups from a separate FM7 file

[David Hart]

FM6 was no trouble, but how do I perform a look up from one FM7 file to another completely separate FM7 file (not tables within a FM7 file)? I have a "telephone log" FM7 File and a "project file" in FM7. From the "telephone log" file I want to look up and copy over from the separate "project" file the project number, description, etc.

[Ender]

Add a File Reference to the external file (File->Define->File References), then you can choose a table from the external file as the source of the lookup. If you have large tables, I'd recommend using an auto-enter calc instead of an auto-enter lookup, as those lookups perform significantly slower in FM7/8 than an equivenant auto-enter calc.

[David Hart]

Thanks for the tip. The manuals do have information on File References, but any reference to Lookups simply refers one to the method of using Tables in the same file. Now I will work on Auto-Calc. Doesn't seem to be intuitive.