BrownFedora

The tables are related via ContactID Contact Table Donation Table ContactID<............>ContactID Name DonationID Date Amount Total (Summary Field) We need to sort or find Names that have a subtotal in given ranges (ie given at least $100, $100 to $1000, $1000 to $5000, etc). How could this be done? I can see subtotals for given names with sub-summaries but I can't not sort or use finds on them. Help will be greatly appreciated.

We have a donation table with fields ID, Date, and Amount We have a calculation field "CurrentYearTotal" that needs to display the sum of all donations (a sum of donations) made within the current year (Jan. 1st to today) Can we do this with out a script and just a Calculation Field? So basically how do I restrict the records that are summed without dong a find. We don't want to do a find because we want to be able to see all time grand total next to current year total. I'll capitulate if a script is the only way to do it but I really prefer not to use one.

Thanks, man. Works perfectly FileMaker Version: 7 Platform: Windows XP

I'm working with FM7Newbie on the same project. To clarify our problem in the PS: We want to be able to search for all contributions made by an individual in the last 3 years to date. This is search will be made 100s of times a day and it would really be a pain to manually enter "04/20/2001...//" everytime I need the syntax to perform a find on the following range: "(Today minus 3 years)...//" so we can hard code a button to do the find in one click (and SAVE A LOT OF TIME).

The client wants to able to look at a compilated activity history that they have for a given contact. It is important to see these activities together in order to see trends or coordinate the next move (EX. you can see Donation was given but no Thank You Letter has been sent yet). There are more activities (volunteering and event attendence) to track but I just listed the two in the example to simplified the explination. I had considered merging the tables but they figured that's be 2 steps back as far as normalization goes (original data was just a giant excel sheet, dozens of fields, no relational structure). We have separate portal views for each individual activity on given layouts, but the portal on the main page should display all them together in relation to their date. Would this be possible with some kind of script? : 1) create an table with generic fields, zero records (Generic Table) 2) for given contact, copy related records from activity tables into Generic Table 3) sort Generic Table by Date 4) display Generic Table in portal 5) empty Generic Table when you move to next contact (back to step 2) and repeat) FileMaker Version: 7 Platform: Windows XP

Hey, I'm developing a Contact Management System for a school team project and we're a little new to filemaker pro. Very new actually. We're working with FileMaker Pro 7 and need to if and how to mix different fields from related tables in a single portal. Here's the deal: The client wants a Contact Activity Log, tracking communication and donation activity. The Communication and Donation are related back to Contacts via 1-to-M relationship Contact Table (ContactID, Name) Communication Table (ContactID, MessageID, Message, Date) Donation Table (ContactID, DonationID, Amount, Date) For a given contact, I can get a portal to show either the related communication or donation info. But what we need is to combine the two, put them in ONE portal, and then sort by Date (I've seen plenty of posts on sorting portals so no need to pass on how to there). Ex. portal should look like below for ContactID - 3 MessageID - 3 | Phone call from Bob | 04/04/2004 MessageID - 2 | email from Mike | 04/02/2004 DonationID - 3 | $50 cash | 03/29/2004 MessageID - 1 | talked with Jane | 02/16/2004 DonationID - 1 | gave painting | 02/14/2004 Is this possible? Can a script do it and if yes, how? Any help greatly appreciated FileMaker Version: 7 Platform: Windows XP