Actually, Jeff, Lauren is right. "New Request" in a find is an OR function, not an AND. And Lauren, unless there's a method I'm not aware of, FMP is not really set up to do AND queries on a single related field. It's something you can do easily with SQL-based databases, but FMP is a whole different animal. I can suggest one way to fake it. Do a find for your first source code. Then, using the Replace command, mark these records somehow in another field. Then do another find for your marked field AND the second source code together in the same request. That should give you the correct found set. The problem is, you may have to repeat this process if you are looking for more than two source codes. Whenever I'm making a db from scratch on FMP, I always include a "tag" field that can be easily set to mark your current found set with a script. I attach it to a checkbox, and then that checkbox can stand in for finds as "everyone I found with my last find". I'd be happy to send you the scripts if you're interested. Send me an email directly if you are. And if there is a more elegant solution, I would love to hear it. HTH, Matthew Scholtz At 01:20 PM 10/9/00 -0700, you wrote: >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 > >> > > > > Matthew Scholtz Evaluator and MIS Coordinator Health Initiatives for Youth San Francisco, CA
