multi level drop down

[nkuebelbeck]

table

id	name	parent_id
1	ford
2	mustang	1

I want to create a multi level selection for my form. I have designed the table above with three columns. I would like the parent_id to display at the first 'level', the second level should be all the id's/names where the parent_id is equal to that level's id. I was thinking I could use a combo box, but I can't for the life of me figure it out. Tried googling for it but I just don't know the right keywords...or it's just not my day.

Here is a visual of what I am trying to create in access.

http://www.red-team-design.com/wp-co...pdown-menu.png

I would like to return the lowest level id and store it for later use.

any help is appreciated.

[rpeare]

Your first combo box should be any record in your table that does not have a parent_ID

SELECT * FROM table WHERE isnull(Parent_ID)

Your first combo box should list only those records associated with the items in your first comb box

SELECT * FROM table WHERE Parent_ID = [Forms]![FormName]![Parent_ID]

In the ON EXIT property of your first combo box (Parent_ID field) have this code:

ChildField.requery

Where childfield is the name of the field that is going to store the model of car.

By the way this is called 'cascading combo boxes' there are a bazillion examples out there (including this forum) if you're looking for the proper terminology.

[rzw0wr]

Another good way;
First combo box code, "SELECT ID, Name FROM table;"

Second combo box code, "SELECT ID, Name FROM Table WHERE ID = " & Combo box1ID;

The Column widths for bot boxes should be 0;1; Showing just the name .

Both will work this just a different way.

Dale

[nkuebelbeck]

This requires two separate combo boxes? I was hoping to get away with just one and nest them somehow

[rzw0wr]

You example shows 2 combo boxes.


Dale

[ssanfu]

You cannot nest combo boxes. You are thinking of something like a treeview list for folders/files? I don't know of any way to do that.

[nkuebelbeck]

You cannot nest combo boxes. You are thinking of something like a treeview list for folders/files? I don't know of any way to do that.

Thanks, I'll just have to use two combo boxes and cascade them.