Searching In Filemaker Pro 11
I am having some issues doing a search in Filemaker Pro, in regards to doing a search using logical operators like in MS Access 2007.
I need to do a search (recently converted Access 2007 database), that will get data from one filed, then have another search take those results and refine them with another field.
Example would be a membership list (multiple years). Find the memberships that active in 2010, then keep those results and also find the renewals in 2011 and display both data as a final results.
This would show members in 2010 and renewals for 2011 in the final output.
Thanks in Advance for steering me in the right direction on this.