July 5, 200520 yr Newbies 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
Create an account or sign in to comment