Jump to content

Lookups from a separate FM7 file


David Hart
 Share

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Newbies

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.

Link to comment
Share on other sites

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.