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