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.
