portal summary

[kozakoff]

Hi,

I'm pretty new to FileMaker, so I hope I can explain my problem. In my database I have portals that contain up to 3 rows. Each row has a "status" field. I'd like to get a summary of one particular value in the field depending weather it is in the first, second or third row. In other words, if the "status" field of the 1st row says "done" and 2nd and 3d rows say something else, I want that to reflect in a separate "master status" field as "done". Same if "done" is in 2nd or in 3d row. Does anyone have an idea if it could be done?

k

[LiveOak]

Create a second calculated field in you line items file based upon status:

StatusFlag (calculation, number) =

If (Status = "Done", 1, 0) <--- this could just say Status = "Done" and will work, it just looks confusing. The equation alone results in a boolean 1 or 0.

In your main file with the portal, create a field:

MasterStatus (calculation, text) =

If (Sum(PortalRelationship::Status Flag) > 0, "Done", "")

"PortalRelationship" is whatever the relationship name for your portal is.

-bd