doing sums in a portal

[paulmetzger]

I have two related databases. For the sake of my NDA, lets call them A and B.

each record in A has a unique id (AID) and has general information about an A.

each record in B is tied to a particular A (matched by AID), and has more specific information.

i'm doing a report in A, and want a portal that will diplay about a dozen fields from each B related to that A. It's going well, but I need to have a running total in the portal. How do I accomplish this?

because my abstraction may have been confusing, here's an example of the output i want

AID: 1 Name: Foo Type: example

field1: bar field2: grok field3: bupkis

----portal----

BID: 1 Value: 2 From: 0 To: 2

BID: 2 Value: 3 From: 2 To: 5

BID: 3 Value: 7 From: 5 To: 12

BID: 4 Value: 1 From: 12 To: 13

----/portal-----

tia,

paul

[paulmetzger]

I did some further googling, and there appears to be a plug in : http://www.troi.com/software/numberplug.html that will do this. Do i need the plugin, or can I make fmp6 do this on it's own?

[cmartin]

You should print this report from the line item file B instead of the master file A. So you will need a relationship defined in B that goes back to A so you can get the info such as:

Name: Foo Type: example

field1: bar field2: grok field3: bupkis

Then you can sum very easily, although you left that part out of your example so I'm not sure exactly what you want.

HTH-

Courtney