AnsweredAssumed Answered

Searching pulling wrong records

Question asked by disabled_fred@tech-wiseservices.com on Sep 27, 2015
Latest reply on Oct 5, 2015 by disabled_fred@tech-wiseservices.com

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

Outcomes