Getting a field to pop up within another field
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".
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"