Using Crystal Reports 2003 and accessing several database tables (via ODBC) I need to select all of the material ids associated with invoices that contain a specific material id. There are about 15,000 invoices that will contain approximately 70,000 material ids. (There is no restriction on the number of material ids that can be associated with a given invoice.) The field names are: InvoiceNumber and MaterialId

In effect I’m trying to say “If InvoiceNumber contains MaterialId “51-103-000000”, then select all material ids associated with that invoice number.

Can anyone help me properly structure the Select Statement?
Thanks,

Krazy (Bill) Kasper
p.s. Happy new Year 2009