multiple listboxes based on previous box

  • Thread starter Thread starter The Boondock Saint
  • Start date Start date
T

The Boondock Saint

Ive got a database which has a tree structure in one table

there is a "category_id" value.. and a "parent_id" value...

the base is when parent_id = 0 this then means there is about 14
listings...

what id like to be able to do.. is click on any of those.. and then in
another drop down box.. it will show all the listings which have that items
category_id as their parent_id....

this could go around 5 deep so id need to be able to have upto 5 drop down
lists etc...

anyone have any ideas?
 
Boondock Saint,

This is a common question. Search the forum for "Cascading Combo Boxes".

Sprinks
 
awesome .. thanks for that Sprinks... i just wasnt sure what the proper name
for it was.. so that helps.. cheers :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row fix-up/updatable join on linked tables broken in Access 2007? 2
solucionar problema 1
Combo Box cascading query 2
list box not getting populated 2
Using values from combo box in subform 2
2005: Warnings 5
Open Form based on Listbox 2
Using results from a Sub Query in a Crosstab Query 4

Back
Top