Here's my problem:

I have a table of "order lines" (lines on an invoice) and a table of "orders". The order-lines table is related to the orders table via an order-id column (1 order has many order-lines). The order-lines table has a component-code column to keep track of the type of product ordered on that line.

I need to generate a report that lists ALL of the order-lines from each order that has at least one order-line with a component code of '49-003'.

I've written many reports, but this one has me stumped! I don't even know where to start. It seems like it should be easy, but I can't quite wrap my brain around it.

Thanks Dewald. I suspected as much.

1. Could you give me some hints how this can be done in SQL?
2. How do I count the '49-003's?

If you are using a Command for the sql you could do it using 'exists'