Query Displaying Repetitious Information

[da poet]

In one table i Have component group Id and the description as fields then another table has the sub groupings for each Component Group Id

Example
Component Group ID = 1 which is the primary key
Description = Keyboards

Component
Sub datasheet has Group ID = 1 foreign key
Descriptive Options = USB, Wireless, PS2, Serial

I have joined both of these in a query but what i want is the query when i link it to the combo box on the form i have to only show the Group ID once and not repeat it for as many times as each subdatasheet has records.

Example: When i click External Device I dont want to see the word Keyboard being repeated 4 times (which is because there are four subrecords/types of keyboards) Please Advise.

 

[modest]

What does the SQL look like in your query? Lookup "GROUP BY"

 

[da poet]

SQL statement

SELECT tblInETypes.[Component Group ID], tblInETypes.Description
FROM tblIEdevices INNER JOIN (tblComponents INNER JOIN tblInETypes ON tblComponents.[Component Group ID] = tblInETypes.[Component Group ID]) ON tblIEdevices.[Category Group ID] = tblComponents.[Category Group ID]
WHERE (((tblIEdevices.[Category Group ID])="a"));


Thats the SQL. By the way i tried using the group by property but itdoesnt seem to avail much change. Im wondering if this is something i should specify on the form itself.

Advise.

 

[neileg]

You need to put the Component Group in the header of the form and the Component records in the detail.