Skip to Content
0
Former Member
Apr 07, 2009 at 12:54 AM

Problem with grouping columns in multiple tables

13 Views

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