2 Replies Latest reply on Feb 17, 2009 2:00 PM by nealt

    Lookup in same table

    nealt

      Title

      Lookup in same table

      Post

      In earlier versions one could lookup a value in the same table as the key. Now that option is gone. What I want do do is when someone enters a value say an item the price field is automatically updated. Item and price are in the same talle of file. So how do you do this in v 10?

        • 1. Re: Lookup in same table
          TSGal

          nealt:

           

          Thank you for your post.

           

          You can still lookup a value from the same table.

           

          When you set up your relationship, click the bottom left icon to add a new table.  Select the existing table, and the screen will show a second occurrence of the table with the extension "2".  Link the key field from the current table to the key field in the second table occurrence.  The rest should be self-explanatory.

           

          If you need additional assistance, or need clarification for any of the above steps, please let me know.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Lookup in same table
            nealt
               Thanks.