Lauren, Where's Charlie when you need him? To conduct a multiple search with FileMaker, you need to create a second or NEW REQUEST. If you are doing a FIND or QUERY, you can use either command keys or the pull down menus to add a new request, which basically serves as the AND function. With the feature, you can also omit parameters from your find. Your FileMaker manual will present this feature in more detail. Jeff Cohn > From: Lauren Braden <[EMAIL PROTECTED]> > Date: Mon, 9 Oct 2000 12:40:47 -0700 > To: "'Margot McKinney'" <[EMAIL PROTECTED]>, > Subject: [SUPPORT] the problem: Correction: How to get found set that > responded toTW O source cod es > > Margot, > Thank you for your reply. The problem I encounter when I try to this > is... the search function (whether I am doing a FIND or a querry) only > allows me to search for ONE source code per search, not two. As far as > I know, Filemaker does not have a symbol for 'and', and the "Add new > request" function acts like an "OR". Any more suggestions? This seems > like a common scenario, when you are searching for people that > contribute to the same appeal year after year. Thanks for any help! > > Lauren Braden, Seattle Audubon Society > > -----Original Message----- > From: Margot McKinney [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 09, 2000 10:56 AM > To: Lauren Braden; ebase tech support > Subject: Re: [SUPPORT] Correction: How to get found set that responded > toTWO source cod es > > > You have to put both criteria in the same request to get AND rather than > OR. > > Margot > Rainbow Families-MN > >> From: Lauren Braden <[EMAIL PROTECTED]> >> Date: Mon, 9 Oct 2000 11:01:00 -0700 >> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >> Subject: [SUPPORT] Correction: How to get found set that responded to > TWO >> source cod es >> >> >> >> Greetings, >> >> I am trying to obtain a found set of folks that responded with a >> contribution to both an appeal sent this year and an appeal sent last >> year (not either, but BOTH). Each of these appeals is represented by > a >> different source code. >> >> What I have tried... In both FIND mode and doing a query, adding a new >> request for the second source code just yields a batch of people that >> responded to one OR the other appeal, not both as I am seeking. >> >> Any suggestions? >> >> Thanks!! >> Lauren Braden, Seattle Audubon Society >> > >
