I have a report that is grouped by order number with a few fields in teh header and running totals for the report in the footer.  I do not show any detail records.  When building the table that feeds the report in VB I check field values for the parent/child tables.  If a parent item for an order is deleted the field is set to "I", if one of the children operations is deleted the field is set to "O" will also be setting the field to "F" if  item is ok to final.  Anyway on the report I need a message field to print if "I" or "O" and a 2nd message field to print if "F" I tried putting the values of the field I set into an array and print the message based on array value but I get a message in the footer of every order, not what I should have! I know this has something to do with the array not knowing it is order number dependant.. Any way I can set an array up so if has order number and when it prints the footer if order number is in the array with one the values I am looking for a message will print?

Not sure, I do not have a detail section. layout is kinda like this

Thanks for the input, I was trying to be lazy and not recode the VB but alas I have went back and spun through all the parents/children on the vb side and now have 1 record per order in the table that feeds the report.  The message field plugs correctly that way as well.