2 Replies Latest reply on Nov 27, 2013 6:57 PM by LyndsayHowarth

    finding and sorting portal

    dvdlghtn

      Hi everyone

       

       

      I am using FM 12 Pro on a Mac, and I am a novice with a 'mind set' that belongs to another industry totally foreign to data bases and I need help.

       

       

      I have a data base file of people's names (first name, last name etc) and have another file which has a portal.

       

       

      What I want to do is have the names show up in the portal where the names have been found and sorted alphabetically on the last name initial.

       

       

      In the data base with all the people's names, I have set up buttons marked 'A', 'B', 'C' etc with scripts that find and sort accordingly. I just do not know how to get the names to show up in the portal in the other file.

       

       

      Any help is much appreciated.

       

       

      David

        • 1. Re: finding and sorting portal
          mikebeargie

          Hi David,

           

          your question was already marked "Assumed Answered" but I didn't see a response.

           

          Take a look at this chunk of code from Todd Geist, it's a pretty elegant way to do what you need with virtual lists instead of relationship driven portals.

          http://www.modularfilemaker.org/2013/03/master-detail/

           

          You might also want to check out:

          http://www.seedcode.com/fm-search-results/

          • 2. Re: finding and sorting portal
            LyndsayHowarth

            Hey Mike... great idea but don't you think he needs some basic understandings of relationships and native FIleMaker before he goes down this path.

             

            David... you can achieve this in many ways. Mikes suggestion is solid... but may be a few steps away from where you are on the learning curve.

            You could...as one option... have FIleMaker calculate the initial letters and using valuelists generate the alpha-buttons for you. left(surname,1) will give you the first letter of the surname.

            When clicking on say "C" you could set a global field with the value "C" (hidden from the user on the pasteboard) which then shows records on a portal where the relationship is between the hidden global letter field and the calculated initial letter.

             

            I'd suggest you access some of the excellent resources (Technical Resource Centre tab above) to find out a bit more about relationships. Also look at Kevin Franks resources particularly AnchorBuoys:

             

            http://www.kevinfrank.com/anchor-buoy.html

             

            - Lyndsay