I have a report that has 2 tables
Invoice LINKED TO SoldItems
I want to be able to look at all of the items sold on an invoice and if one of the items equals Category 1 I want a Flag that is set to True for all of the items in the Invoice. If no items exist in Category 1 then the Flag shoudl be False for all Items.
How do I do this?