1 2 Previous Next 15 Replies Latest reply on Oct 5, 2015 9:33 AM by disabled_fred@tech-wiseservices.com

    Searching pulling wrong records

      Greetings:

       

      I am having a difficult time getting my find results to show.

       

      I created a membership database in FMP 13. Fields include contact information, membership year, etc

      For membership year I created a value list since we use a fiscal year: 2010-2011, 2011-2012, 2012-2013,...

      I created a table to show the current year memberships (2015-2016, FirstName, LastName, Email, etc).

      In my criteria, I conducted a Find for MembershipYear 2015-2016....NOW the trouble begins.

      My query pulls the right number of records from the DB.

      My query pulls the correct names for 2015-2016. HOWEVER,...

      My query does not show the correct membership year (2015-2016). AND

      My query does not show the correct service criteria (President, Director, Treasurer, Secretary, etc).

      My query shows the first record of membership date and first record of service.

       

      Let me try to explain:

       

      I have been with organization since 2010-2011 year. Thus, my membership data shows

      MembershipYearFirstName
      2010-2011Fred

      2011-2012

      Fred
      2012-2013Fred
      2013-2014Fred
      2014-2015Fred
      2015-2016Fred

       

      When you add my service with organization the data shows

      I have been with organization since 2010-2011 year. Thus, my membership data shows

      MembershipYearFirstNameHeader 3
      2010-2011FredTechnology Director

      2011-2012

      FredTechnology Director
      2012-2013FredTechnology Director
      2013-2014FredTechnology Director
      2014-2015FredTechnology Director
      2014-2015FredTreasurer
      2015-2016FredTechnology Director
      2015-2016FredTreasurer

      Please notice I have more than one service duty for the last two membership years (2014-2015 and 2015-2016).

       

      My query results shows something similar to

      MembershipYearFirstNameHeader 3
      2010-2011FredTechnology Director

      2015-2016

      SueEditor
      2013-2014SamPresident
      2015-2016JanProject Director
      2015-2016JohnConference Chair

       

      What should be showing

      MembershipYearFirstNameHeader 3
      2015-2016FredTechnology Director

      2015-2016

      SueEditor
      2015-2016SamSecretary
      2015-2016JanProject Director
      2015-2016JohnConference Chair
      2015-2016FredTreasurer

       

      Fields

      ServiceYear

      Position

      FirstName

      LastName

      Phone

      Email

       

      Script

      Enter Browse Mode []

      Go to Layout ["Member in Service 2015-2016" (Contacts)]

      Perform Find [Restore] {The find here is Find Records Service::Year: [==2015-2016]}

      Sort Records [Restore; No dialog] {This is sorting ASC FirstName, Last Name]

       

      I am so at a loss! Any wisdom is greatly appreciated...fred

        1 2 Previous Next