Report/Subreport Conditional Formatting

[BSmith]

Here's the situation:

Card Table and Job Table have a many-to-many relationship with a junction table that ties the two primary keys together.

The way this is set up is, I have a form that selects the Card with a checkbox.

"Card Table Query" (based on the Card Table) lists all selected Cards.

[SIZE=2]SELECT DISTINCT [C Card Table].CardID, 
[C Card Table].[Card #], [C Card Table].[QA Task], 
[C Card Table].Area, 
[C Card Table].[BFL Task], [C Card Table].[Pub Removals], 
[C Card Table].[Pub Task], [C Card Table].[Pub Restore], 
[C Card Table].[Pub Test], [C Card Table].Title
FROM [C Card Table]
WHERE ((([C Card Table].Selected)=True))
GROUP BY [C Card Table].CardID, [C Card Table].[Card #], 
[C Card Table].[QA Task], [C Card Table].Area, 
[C Card Table].[BFL Task], [C Card Table].[Pub Removals], 
[C Card Table].[Pub Task], [C Card Table].[Pub Restore], 
[C Card Table].[Pub Test], [C Card Table].Title[/SIZE]

Job Query (based on all three tables) that shows all jobs associated with the selected cards.

[SIZE=2]SELECT DISTINCT cardjobjunction.JobID, CardJobs.[Job #], CardJobs.Component, 
CardJobs.Access, CardJobs.Task, CardJobs.Test, 
CardJobs.Restore[/SIZE]

I have a report based on a "Card Table Query" that gives me all Cards that are selected in the "Card Table".

I have another report based on "Job Query" that gives me all the jobs from a table named "Cardjob Table Query".

How can I link these reports to show the Card and then it's associated jobs in a subreport? So, it's all on one report.

And if that is possible, how can I identify (text in red) if duplicate jobs show up on different cards?



I've been working on this for a month and this is a major brick wall for me. I have a deadline creeping up on me and any help would be very much appreciated!!

 

[BSmith]

Nevermind, I figured it out.

In case anyone's interested, I basically created one report with one subform based on the Job Table Query and one subreport based on a third query that created a list of all duplicated jobs.

I had a time working out the correct parent/child relationships.

I used conditional formatting for the job in which an expression was written to say that if job on one sub report was equal to the job on the second subreport (report not visible) then turn text red.

I know this is a very high summary.... if you want details, let me know.