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