I am new to Crystal and the problem I am having is:

 

I am trying to pull data from 2 tables - from an OrderHead table and an OrderDetail table. 

I need all the order numbers pulled just ONCE from the orderhead table and need a department group number from the orderdetail table.  The problem is that the order detail table has multiple lines per order - so when I add the department group number, I am getting multiple order  numbers due to the multiple lines from the orderdetail table. 

The department group number is only in the order detail table.

 

In Access, I would have just used a "first" function for the department group number, but in Crystal I can't seem to find out how to do this.  It seems like it would be simple, but just can't seem to get it to work..

 

Any help would be much appreciated!

Thanks

John

I tried this in the field format and what it did was the same thing as "suppress if duplicated" does in Crystal XI.  It hides the duplicates, but does not exclude them.  I found a few other things on DISTINCT - so need to look into that.  This might be what I am looking for. 

 

John