Problem with grouping multiple tables in crystal reports

[victor64]

Hello,

Table 1 contains

ID Make
1 GM
2 Ford
3 Chrysler

Table 2 contains

ID Colour
1 Red
2 White
3 Blue


LinkTable contains

ID Make_ID Colour_ID
1 1 1 (GM Red)
2 2 1 (Ford Red)
3 1 3 (Ford Blue)

My report is group by the two columns in the LinkTable

Group1 is grouped by Make_ID from the LinkTable, the Make field from the Table 1 is also included in Group 1

Goup 2 is grouped by Colour_ID from the LinkTable. The problem occurs when I insert the Colour field from the Table 2.

I can't figure out why group 2 is not work, please Help.

Thanks,

Victor

[jggtz]

Colour table is empty