Newbies kozakoff Posted August 7, 2001 Newbies Share Posted August 7, 2001 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 Link to comment Share on other sites More sharing options...
LiveOak Posted August 7, 2001 Share Posted August 7, 2001 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8296 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now