Cascading combo box

[mwieting]

Okay I am really struggling with getting a cascading combo box to work.
Ive attached a Visio doc to help illustrate what I want to do.

Basically My combo box has choices that come from my table (named Asset Types). When I select desktop, for example, I want to data from my desktop form named (Desktop) to show up so I can then enter the given criteria. If I choose laptop from my drop down I want to see my laptop data (Laptops). There will be other devices but I hope that this will help get the point across. If anyone could help me that would be great.

 

[pbaldy]

See if this helps:

http://www.baldyweb.com/CascadingCombo.htm

I would not have separate tables for laptops, etc, since the fields are the same. I'd have a single table with a field for the type of asset.

 

[mwieting]

So based off that link you sent, what would I substitute in for cities in the example?

 

[pbaldy]

That would be items of the type of asset chosen in the first combo. If you stay with your multi-table approach, you'd have to use the code version and actually change the table used for the second.

 

[mwieting]

I guess i am a little confused with what info and where to place it in the script....