Include All items or just by group.

[bnickelsen]

Here is what I have:

tblItemList:
IDItemList AutoNumber Field
ItemName Text Field

tblGroupingList
IDGroupingList AutoNumber Field
GroupName Text Field


tblItemDetail:
IDItemDetail AutoNumber Field
fkToItemList Number Field Joined to tblItemList
ItemVender LookupField
ItemavgCost Currency Field
ItemSRP Currency Field


tblItemGroupDetail:
IDItemGroupDetail
fkToItemList
fkToGroupList



Next I will add some tables to show orders. tblOrderList, tblOrderDetail ect

When I build the forms for the Orders I want to be able to show the list of items. Currently I have 16 Groups that Items can be in. An Item can have one or more groups or not be in a group at all. I would like to make the items selectable from drop down menus. But sorted by groups. So I would have a combo box of the group names. By setting it to "group one" the item combo box shows only items that are in "group one".

The part I am getting stuck on is how to "show all items" while not show the same item multiple times.
I am trying to do this in a query and can not seem to get it.

Any suggestion?