combobox hierarchy

[linux_s2002]

Hi guys!
is it possible to have a combo like this?



I have 2 tables:
table1 => id; description that contains (veg, Fruit, eccc)
table2 => id;descrption; idTable1

in some case, i have record in table1 but not in table2

Thank you!!

[Welshgasman]

If you prefixed Carrot etc with spaces I would expect you could get that layout.
Otherwise a treeview might work, though they can be complicated to set up. I have never created one.

Normally one would use cascading combos.

[ArviLaanemets]

tblGroups: GroupID, GroupName; -- group names are like 'Veg', 'Fruit', etc.
tblProducts: ProductID, GroupID, ProductName --- Product names are 'Carrot', 'Apple', etc.

You can create a combo box with RowSource property like:

SELECT prod.ProductID, IIf(Nz(group,GroupID,0)=0, "", group.GroupName & ": ") & prod.ProductName AS Product FROM tblProducts prod LEFT JOIN tblGroups group ON group.GroupID = prod.GroupID ORDER BY 2 DESC

This design allows products with undetermined groups. In case you have a group for every product determined, you can skip the check for GroupID being Null in Rowsource query.

The selection list the combo will display will be like (all products are grouped by group, in case tis is present):
Fruit: Apple;
Veg: Carrot;
Veg: Eccplant;
Veg: Potato
Veg: Pumpkin;
...

[CJ_London]

You can create a made up combo using a subform - the subform can then use conditional formatting for the bold and do things like ignore selection of the headings

[linux_s2002]

Thanks!!! I try it now...