2 Replies Latest reply on Dec 8, 2008 9:00 AM by ralvy

    Browse Mode Lookups

    ralvy

      Title

      Browse Mode Lookups

      Post

      This quandry probably comes from not fitting into the FMP mold yet, but here goes. I'm used to constructing a RDMS application (with a different RDMS) so that the user, in Browse mode, can perform a lookup to find a particular record. More specifically, performing a lookup on the Last Name field shows the user a table of possible records for that particular data file, alphabetically sorted by Last Name. When the user types some letters, the highlight bar moves closer to the desired record. When the desired record is found, the user hits Enter and that record is loaded for examination or editing.

       

      The closest ways I have found to duplicate the above is the following:

       

      Add a global field to the table. Create 2 TOs for this table and link the global field from the first TO to the ID Number on the second TO. Create a layout based on the the first TO. Put a DropDown lookup field in that layout, and have it point to the first TO's global fiield. Have it access a Value List that is built on the ID Number field of the same table, and have it display and sort the Last Name field of that table. Then put fields in that layout that point to fields in the second TO.

       

      This way, when I load the layout and touch the lookup field (the global field of the first TO), I see names sorted by Last Name from that source table. When I pick one, the fields in the layout are populated with values from the second TO.

       

      This seems to work, but it seems like a lot of work to make this happen. I have a sneaky suspicion that there's a more to-the-point method for this.

        • 1. Re: Browse Mode Lookups
          TSGal

          ralvy:

           

          Thank you for your post.

           

          Your way is just as good as any.

           

          Another option would be to create a value list that is dependent/linked to the related table, and then use the field with a drop-down value list.  When you click on the field and the drop-down values appear, just type the first few characters and the first entry for those characters will be highlighted.  You can then use the arrow keys to move down to the appropriate record and select it.  However, since you may have thousands of records, this would probably not be a viable solution.

           

          Anyone else have some ideas?

           

          TSGal

          FileMaker, Inc.

          • 2. Re: Browse Mode Lookups
            ralvy
               That's what I'm doing. I'll import a few thousand records and see what happens. With the DOS RDMS app I use now, the lookups take less than a second, and find the correct record takes about the same amount of time.