Crystal Report In Window Forms

H

hibiki1979

Member
Joined
Jun 19, 2003
Messages
8
Location
singapore
Hi,

I am trying to display fault code field and part code field in crystal report link by a job number. However, there are 3 tables: one for keeping job number, one for keeping fault code relating to a job number and the last one is for keeping psrt code relating to a job number too. Hence, they are linked by the job number.

However, the part code and fault code can have many part codes and fault codes for a single job number. This is where the error occurs when i try to display distinct fault code and part code of a particular job number. Eg: If i have 2 part codes and 2 fault codes relating to 1 job number, it will display 4 lines instead of 2 lines when displaying the part codes and faults. In order words, it is doing all possible combinations between the part code and the fault code

In Database
----------------
Part Code Fault Code
------------- --------------
a b
c d


Displaying
-------------
Part Code Fault Code
------------- --------------
a b
a d
c b
c d


May I know how can i solve this problem? I want to display it like this:

Displaying
-------------
Part Code Fault Code
------------- --------------
a b
c d


Thx.
 
Back
Top