I'm having a problem with some related records.

I have a table that has a series of "trips" related to a table called "states". Each trip record has a "state" field and the "total miles" traveled in that state. Each trip record also has a date. A relationship was made between trips and states where state equals state and date falls between a start and end field in the states table.

I have a portal based on the state table that shows me a list of states for a given client. I have placed in this portal a field for the "state" as well as a calculation field that is a summary of the "total miles" field. It seems to be working properly accept that it only returns a calculation for what appears to be the very first "state" record. In this case - Arizona.

Can anyone tell me what I am doing wrong?

What does your calculation look like? It should be like Sum(relationship::total miles).

I fixed it. One of the fields I was using in the relationship need to have a "global" storage attribute. Once I did that, everything started working just fine.