This might be hard to explain, but I'll do my best. I'll keep my example simple and say that I have a report with 2 group values, Leader and Support, each with 1 detail record within it:
Leader
-Mary
Support
-Bill
I also have a table that's not part of the control set for the report. Let's say it has 3 fields. ID, LeaderSelected, SupportSelected.
I'll also say it currently has 1 record: 50, Mary, John.
I want to look in that table to see if Mary is in the table in a field that's name includes the value of the current group, turn the background of the field red.
So in my example, Mary in the Leader section of the report would turn red, because she's listed in the table in the LeaderSelected column.
That's horribly confusing. Sorry. Any help is appreciated to figure out if this is possible.
Leader
-Mary
Support
-Bill
I also have a table that's not part of the control set for the report. Let's say it has 3 fields. ID, LeaderSelected, SupportSelected.
I'll also say it currently has 1 record: 50, Mary, John.
I want to look in that table to see if Mary is in the table in a field that's name includes the value of the current group, turn the background of the field red.
So in my example, Mary in the Leader section of the report would turn red, because she's listed in the table in the LeaderSelected column.
That's horribly confusing. Sorry. Any help is appreciated to figure out if this is possible.
