Calculated donations solicited by an individual

[Dirk E]

Hello -

I am creating a database to track donations and solicitations to a non profit group.

I have three relational tables, the first holds individual person records. The second holds the data of how much they have pledged to donate/solicit. The third table holds the actual donations. Donations I am tracking by Individual ID. There is a second serial number named Solicitor ID. If a person donates, say, $100 and give credit to a solicitor, I mark that by attributing the donation to both IndividualID and SolicitorID.

I have been successful in creating a summary field that shows on a layout how much an individual has donated, but I can't seem to get a field to show how much a given SolicitorID should credited for. Does anyone know how to create this field/calculation? I think this is a relatively simple thing to do but I have just started working in filemaker and may be a little green.

Thank you for any help - I am more than willing to help supply more information if needed.

[RalphL]

Make a relationship from Individual to Donation IndividualID = :SolicitorID. Use the Sum function with this relationship. Sum (Relationship::Amount)

[Dirk E]

I'm reworking all the tables now, I think I have to break out a bunch of the stuff I had in certain tables into others.

Thanks - I am sure I will have some other questions. But I am going to basically make the IndividualID = SolicitorID in a different Solicitations table.