Skip to Content
0
Former Member
Feb 24, 2009 at 05:27 PM

problem when linking 2 db tables [Crystal Reports]

27 Views

Hi,

I am pretty new to Crystal Reports. I am working from 2 database tables which i linked together by one field. I created a table and am trying to display all the customers id's

However, what is happening is that multiple same customer id's are in the table because there are more ordernames for each customer.

My tables are pretty much set up as this (though this is a simplified version of the data in each of my tables)

ie.

customer (table1)

-


customerID

order (table2)

-


customerID

ordername (can have the values 'apple', 'orange', 'banana')

Im wondering how i can get it so that a customer ID is displayed only for say 'bananas' in the order table?

Thanks

J