Custom generic inquiry is giving duplicate lines

Hi ​@pankaj65,

1. Open the "PSSummitRoading" inquiry

2. Go to the "Relations" tab and modify the table relationships:
   First, verify the PMTran -> PMRegister relation exists and is configured correctly
   Then update the relationship chain to be:
   PMTran -> PMRegister (already exists)
   PMRegister -> EPTimeCard 
   EPTimeCard -> EPTimeCardItem

3. Remove the direct relationship between PMTran and EPTimeCardItem since we'll be connecting through the proper chain

4. The relations should be set up as follows:
   For PMTran -> PMRegister:
   Parent Table: PMTran
   Child Table: PMRegister
   Join Type: Left
    Conditions: 
    RefNbr = RefNbr
    TranType = Module

   For PMRegister -> EPTimeCard:
   Parent Table: PMRegister
   Child Table: EPTimeCard
   Join Type: Left
   Condition: OrigNoteID = NoteID

   For EPTimeCard -> EPTimeCardItem:
   Parent Table: EPTimeCard
   Child Table: EPTimeCardItem
  Join Type: Left
  Condition: TimeCardCD = TimeCardCD

5. On the "Grouping" tab:

Since you mentioned grouping by PMTran.NoteID works, keep that grouping if desire

You might want to add additional grouping options:

EPTimeCard.TimeCardCD

EPTimeCardItem.LineNbr

This should resolve both the duplicate results and ensure the Road Name/Skid No field displays the correct values for each line.