2 Replies Latest reply on Mar 9, 2009 6:50 AM by toymaker

    look up failure

    toymaker

      Title

      look up failure

      Post

      I migrated from fm 5.5 to 10. I have a customers table and an orders table with the phone number as "look up" field. So when I enter the phone number on the orders table all the contact info fills in automatically. When I lauch fm it works fine. Sometimes twice and more. But fails each subsequent time, until I restart fm. Any idea whats going on?

       

      thanks,  John the toymaker 

        • 1. Re: look up failure
          RSchaub
            

          Sounds like your reference to the customers table is broken. Did you copy the tables into one file or are they still external files?

           

          Try re-establishing your relationship and check your exteral data sources and make sure the path is correct and there is only one path the customer table.

          • 2. Re: look up failure
            toymaker
              

            The two files are external files. The relationship path seems good and does indeed work for 1 or more new records in the second file. Then it just seems to quit looking up.

             

            thanks for your time,  john