krswitky

Greetings all, I've got a new FMP7 database that includes a table for DONORS, MAILINGS, and MAILINGSRECEIVED. The last table manages the many-to-many relationship for donors and mailings, and includes fields for the DonorID and the MailingID. On a layout based on DONORS, I'm looking at a portal of MAILINGSRECEIVED and see the list of all mailings that have been sent to that donor. I can add records to this portal. This all works just fine - so far, so good. My question is whether I can use a script to add records to this MAILINGSRECEIVED table, one each for a group of donors. The problem I'm trying to solve is this: I have a group of, say, 400 donors that I have found via multiple finds in the DONOR table. I want to mark each of these records so that I can tell that they've received my next mailing. I can do this manually, but I'd like to automate it. What I'm envisioning is a solution that would ask the user what mailing the group would receive. The user would select a mailing (from a value list generated via the MAILINGS table), and then give FMP the go-ahead to create a record in CAMPAIGNSRECEIVED for each donor in the found set, for that mailing. Is this possible? Or is there another / better way to solve this problem? Many thanks to anyone who might have some help to offer. Kathy

Here's a slight variation on the original question. I am new to portals and am unsure how to do a different kind of find. Same basic setup - an individuals db, and a donations db, related by ID number. In the individual db I have a portal that shows that person's donations. I would like to do a find on all donations of a certain size in a certain date range (again, an "AND" request, but of a different sort). If I request find date>1/1/2001 and gift size>99, I get records for any individuals who made a gift (of any size) >1/1/2001 OR who made a gift (at any time) >99. Is there a way to do the "And" find I'm looking for? (I'm hoping I'm missing something basic here!) Many thanks--Kathy