sub summary 'stuck'

[ron G]

It has been awhile since I created an application in FM and I think I have forgotten something fundamental.

Here is the situation (I am using FM 11 ADV):

There is a non-profit association of homeowners.

We need to collect property, owner, payment and water meter reading information.

So, I created these tables:

Owners

Property

Payments

MeterReadings

(the .zip file has the table)

Everything works pretty well except the Rpt Payments report DOES NOT break when there is more than one property owned.

(ie, Joe Schumfutz owns 2 properties: 11 Schumfutz Drive and 12 Schumfutz Drive. The report only shows 11 Schumfutz Drive

despite the fact that if you look at Property layout, it shows he clearly owns these 2 properties.

Can you kick me in the backside side and remind me why the sub summary won't break on the property Address?

Thanks

HVEWater.fp7.zip

[comment]

It's because a payment is related only to owner - not to any specific property of the owner. You have the field there (fkPropID) but it's not linked to anything.

[ron G]

It's because a payment is related only to owner - not to any specific property of the owner. You have the field there (fkPropID) but it's not linked to anything.

Right.

I created a 2nd instance of Payments and linked it's fk_PropID to Property::PK_PropID and it works.

But, since Payments is related to Owners and Owners is related to Property, why can't a sub-summary report based on Payments get to all the property records of an owner. I can see that it doesn't but doesn't it seem like it SHOULD?

[comment]

I created a 2nd instance of Payments and linked it's fk_PropID to Property::PK_PropID and it works.

Well, strictly speaking, Payments should be related to Properties only. Since a property has only one owner, the owner is known once the property has been identified - so the fk_OwnerID field is redundant.

why can't a sub-summary report based on Payments get to all the property records of an owner

It can and it does - but it cannot tell them apart. If you had a portal there, it would show all addresses of the owner's properties. As it is, it shows only the address of the first related property.