victor64
Apr 7th, 2009, 06:08 AM
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
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