Total amount from another database?

[Darren M]

Hi everyone... long time listener first time caller

I'm positive this is an easy answer one but I can't wrap my tired little brain around it. Working on a donations database that I inherited, and normally I would've just destroyed this POS and started from scratch, but that would've meant over 1000 records to re-do. And guess who would've had to do it. Anyway.

Two databases, relationship is the Donor ID field. One database is the pretty front-end, the other is the line item listing of each individual donation. On the line item database, there is a field that correctly summarizes the total amount of $$$ donated by this one donor ID. On the pretty database, I can't get this to work at all. It just keeps giving me the total amount donated. I've tried calculations that just summarize based on sorting and fun stuff like that, but it never works.

Line item database

RelatedDonor.fp5

"Donor ID" "Name" "Donation Amount" "In Memory of"

10110 smith, agent $150 Neo

10110 smith, agent $20 Trinity

10110 smith, agent $75 Morpheus

Donation total: $245

Front-End database

DonorDatabase.fp5

Portal field showing all records matching Donor ID

How to obtain the donation total for just that Donor ID. Works with some button scripts as shown below but there must be a simpler, automated way to do this.

DonorDatabase.fp5 script (find total)

Copy [select, "Donor_ID"]

Perform Script [sub-scripts, External: RelatedDonor.fp5] (total lookup)

RelatedDonor.fp5 script (total lookup)

Enter Finder Mode []

Paste [select, "Donor_ID"]

Perform Find [Replace Found Set]

Perform Script [sub-scripts, External: "DonarDatabase.fp5"] {refresh}

DonorDatabase.fp5 (refresh)

Refresh Window [bring to Front]

Go to Field ["testing"]

Go to Previous Field

--

I apologize for being wordy, I just wanted to be thorough with my explanation TIA for any insight!!!

[slstrother]

A calc field in your DonorDatabase.fp5 file should do it.

Sum(RelationshipName::Donation Amount)

Replace "RelationshipName" with the name of the relationship using the Donor ID field.

[Darren M]

WTF! I swear I did that and it didn't work!!!!!!

Gah.

I'm gonna go bang my head into the wall. Repeatedly.

Thanks.

[Ugo DI LUCA]

It surely should work.

Are you using the same relationship ?

Are you targetting The Customer Total instead of DonationAmount ?

By the way, what is your calc for Donator Total in the Line Item ?

Should be the same Sum(SelfJoin::DonationAmount)

[Lee Smith]

Ugo -

I think he is saying that it does work. I also think that he is saying that he thought he had already tried it before asking, but apparently he hadn't.

We have all done that.

Lee

[Ugo DI LUCA]

Oh yes !

And yes we ll did that....and stil are.

>>I'm gonna go bang my head into the wall. Repeatedly.

Someone just suggested that I keep my helmet off.

[Lee Smith]

ROTFLMAO

What a great use, I think I'm going to go buy one. Should be able to pay for it from what I'll save on aspirin.

[Ugo DI LUCA]

Lee,

thebellstore is what you need.

[Darren M]

Lee Smith said:

Ugo -

I think he is saying that it does work. I also think that he is saying that he thought he had already tried it before asking, but apparently he hadn't.

We have all done that.

Lee

Heh yes what he said... it did work. I swear I tried that before and it never worked right. I knew it couldn't be anything serious, I just didn't understand why it didn't work. I guess I must've picked the wrong field to total, I dunno

Yes pounding your head into a wall is more effective sans helmet

Thanks again.