how to sum selected records from related table?
I have a table called Floor which is linked to a table called frames via a lines table.
On a layout i have a portal to the floor and the frames table. With a global field i select a floor in the portal which displays related frames for that floor in the frames table. I want to be able to the total of each frame on a floor, in the frames portal.
I'm trying to do a sum calc field in the frames table but it doesn't show the sum of how many times that frame has occured on the selected floor. It shows the total sum in all floors.
Can anyone please advise on how to proceed.