2 Replies Latest reply on Sep 17, 2014 9:53 AM by raybaudi

    Lookup with Multiple Values



      Lookup with Multiple Values


      Hi, I'm very new to Filemaker and need some help on this. I have a lookup function that gives me the result from a different table based on a unique field. However, it only gives me the first value and I'm looking for a way for FileMaker to give me the 2nd Matching value, 3rd matching value and so on. How is this possible? Thanks. 

      I found this site that offers a solution for Microsoft Excel but not one for FileMaker yet : http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_10590-Finding-the-Nth-Lookup-Value-in-an-Excel-List.html