Status of related records problem

[jstaphase]

I'm having with a tracking idea. I have 2 tables, jobs and line items. I'm trying to show the status of all related line items on the jobs layout. ex. the jobs layout has "ironing required" field that shows it's needed. Each line item has the same field. I'm trying to get the jobs layout to show "ironing needed", even if only one record needs it.

Currently, when the first related record is "needed", it shows, otherwise it's ignoring the other related records.

Please help. I've attached an example file, because I'm awful at explaining what I mean.

Thanks

IroningExample.zip

[-Queue-]

Relationship::field only refers to the first related record, not all of them. To test all of them you need a value list. Create one based on line items::ironing needed and 'Include only related values starting from' jobs. Then change your 'needs ironing' field to bbe an unstored calculation of Case ( PatternCount( ValueListItems( Get(FileName); "ironing" ); "Yes" ); "Yes" ).