AnsweredAssumed Answered

Getting a field to pop up within another field

Question asked by JDen2775 on Nov 4, 2008
Latest reply on Nov 4, 2008 by davidhead

Title

Getting a field to pop up within another field

Post

Ok, simple inventory database.  Under Categories, I have 10-11 of them.  Under each of those I have 10-100 items that I have created under individual Value Lists. 

 

How can I have one field "Categories" on my layout, click on "Office Supplies" from a drop down, and immediately have the "Office Supplies" items show up in another drop down?  Then ideally from this drop down, another drop down would show up asking for "quantity".

 

Any clue?

 

Right now I have all the Categories as seperate fields with drop down menus, and seperate quantity fields for each one,  and it is cluttered.  Hoping to make it more "automated"

 

Thanks!

Outcomes